News Focus
News Focus
Followers 210
Posts 7903
Boards Moderated 15
Alias Born 05/24/2001

Re: Rick Faurot post# 764

Saturday, 12/27/2003 9:30:53 PM

Saturday, December 27, 2003 9:30:53 PM

Post# of 985
It's unlikely I'll make a whole-database search available in the near-term. The entire message table is full-text indexed (took about a week just for that process to finish) and it's slow as molasses. We're talking 30-60 seconds to complete searches and they clobber the server.

So I'll probably only make the most recent 2 million messages searchable initially. And try widening that window until I find the widest window that still allows acceptable (less than 10 seconds) performance.

Discover What Traders Are Watching

Explore small cap ideas before they hit the headlines.

Join Today