Silicon Investor (SI) -- The First Internet Community

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

To: Joe NYC who wrote (17)	12/14/2004 5:21:08 PM
From: SI Bob	Read Replies (1) \| Respond to of 81

In case you were interested, I got a server error when I tried to do a search on a subject (on AMD Moderated thread) last night. I'd guess that was probably a one-off. The database server might've been unusually busy or the internet connection at the ISP blinked out right when or before you did your search. I just did a full-text search there and after playing with iHub's full-text search today, our seems amazingly fast! I searched the AMD thread on the word "search" and I'm not even sure it took a full second to get the results.

To: Joe NYC who wrote (17)	12/14/2004 9:15:55 PM
From: SI Dave	Respond to of 81

>> I got a server error when I tried to do a search on a subject (on AMD Moderated thread) last night. Unless Bob has changed something, that was probably because the query contained only Ignored words. I changed the "Subject Title" and "Board Description" searches to use the "freetext" alternative to "contains" so it wouldn't throw an error. That would probably be too expensive on message searches. I suspect we just need to modify the routine to return the DB error code and handle it elegantly. Perhaps we could use freetext on Subject search (not Advanced search) since it's limited to a relatively small search table? Bob?