</font><font color="blue" class="small">( <font color="blue"> Would it then follow that if I had to do 10 searches to find what I'm looking for, it would slow things down more than doing one larger search? </font>
Your 10 searches would be done sequentially, each separated by human intervention to type in the next forum to search. In essence, 10 'little' searches versus 1 'big' search.
Typically, a database that's designed for interactive access, i.e., responding to many requests each of which does not last long, doesn't run well with requests that last a long time, e.g., a search.
For those with computer experience, reading and writing posts is an interactive process. Searching is a batch process. )</font>
Okay, here's a thought then. Note that I didn't say it was a good though, merely that it was a thought. /forums/images/graemlins/grin.gif
If someone wanted to search the entire archive of posts, would it be possible/workable/easy to launch that search as a batch job, running at low priority in the background, and to mail the person the results when the search concluded?
My main concern is that, being unable to find the appropriate thread, where the new post really belongs, people will simply begin a new thread. In the long run, which is worse... having multiple, redundant, threads, or giving people *some* way of finding the thread that they know exists but can't find?
I know that often threads wander.. and a thread on "John Deere hydraulics" will often end up with posts about hydraulics in general, hose connection techniques, which hoses to use for what, how to connect air hoses, and so on.. ad infinitum. I don't see any way around that happening.. given that we are all mere humans doing the best we can to communicate something helpful. /forums/images/graemlins/grin.gif
So... perhaps an option for a *slow* search.. you could program these to run at non-prime-time hours, to run at low priority, to take as long as they want, to be pre-empted by interactive requests, and to mail the results whenever convenient.
Again, just a thought! /forums/images/graemlins/grin.gif
Bob