The Question and Answer Board

[Bob Zumbrunnen]

Correct. Yes, we could add "Next 50" to Search right now, but Search really is an expensive mess with this kind of traffic on this version of SQL Server.

We're working toward it. The new webserver will be installed this Saturday. Doesn't help Search, but it's a step toward it. Next up (1 to 3 months) is a new database server with SQL Server 2005.

Once we're on SQL Server 2K5, then we'll tackle search. At this point, I see any effort put into search as effort completely wasted. Like doing open heart surgery on a death row inmate a month before his execution. Most of how it's currently done (on both sites) will be completely scrapped to take advantage of new functionality. And I'm hoping and half-expecting that I'll no longer have to break search tables out by year.