Silicon Investor, under the hood Message Board

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Pastimes : Silicon Investor, under the hood

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: mas_ who wrote (2)	12/12/2004 8:52:33 PM
From: SI Bob	Read Replies (1) of 81

The bit I am not clear on is why MSSearch needs to be called. Can you not construct a table which includes the message text as the major column with the thread id,author as the primary key ? That way you can reduce searches to just a one thread table. A way can be written to get around MSSearch, but it's not easy and has a few drawbacks. It's a possibility if the next version of SQL Server doesn't. Most searches aren't thread-specific, though, so making separate tables for all the threads wouldn't be worthwhile. The performance for a thread-specific search would be incredible, but at the cost of having about 30k separate tables and catalogs hanging around, all of which would need frequent updating. And if it were tried without MSSearch (using LIKE instead) the performance would be extremely poor on many threads. thread id,author as the primary key Thread id/author wouldn't be unique, which a primary key must be.

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next