I have a big problem with search speed - queries that contain common words are very slow. I have an index of 200,000 documents on one server; all files are plain html with just title and body text, 3-40kb size. Searching with one word queries that return less than 1000 results are very fast - about 0.1 sec or even faster. But if any word of a query matches many urls (e.g. 'word' matches 58000 urls), the search takes over 5 seconds (up to 25 secs, if several common words are used together). I had the same problem with MnogoSearch, but in that case query time was exponentially dependent on the number of results returned, and queries with more keywords (and thus fewer urls returned) were faster. In aspseek the situation is the same, but looks like the search time is exponentially dependent on the sum of the url all keywords of the query return, not on intersection.
Please HELP!!! I'm desperate - the server load reaches 87% - it is critical. Best Max
