SI
SI
discoversearch

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 -- Ignore unavailable to you. Want to Upgrade?

To: mas_ who wrote (15)12/13/2004 11:54:21 AM
From: Joe NYC  Read Replies (2) | Respond to of 81
 
mas,

and you would do this to be able to do a sequential read of the records, and avoid full text search? Doing it on a thread like AMD moderated thread with 150K messages would most likely not work. Just reading the 150K messages (assuming 500 bytes per message) would be 75 MB of data to read and of course do string comparison would take a lot of CPU cycles.

Joe



To: mas_ who wrote (15)12/14/2004 5:16:59 PM
From: SI Bob  Respond to of 81
 
That likely wouldn't help subject-specific searches at all because even with subjectid being a non-clustered index, the real overhead is still MSSearch. Making subjectid clustered might save me a few milliseconds. A drop in the bucket when MSSearch itself costs full seconds.


HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News