The Question and Answer Board

[Bob Zumbrunnen]

Advanced Search will be the only way to search pre-2005 now.

The performance problem with Search retrieval (which is completely cured now) was because we were searching one huge table.

And the way Search works in SQL Server, it does no good to add other limiting criteria to the query. If you want to find all of my posts in which I wrote the word "search", no matter what I do or how much it ticks me off that it works that way, it first finds ALL posts containing the word "search", then filters them down to just my posts.

Just not workable to have it work against the whole message table when it's gotten as large as it has.