Re: Some fulltext queries hang miserably

[Apachez]

Maybe doesnt help in your case but I have found mysql's fulltext engine to be rather slow when there are huge resultsets which needs to be sorted.

One example is to search in boolean mode for the 10 most common words in a table (a query which has these 10 words) and sort by date.

Thats why I have been digging with my own vectorbased searchengine to fix this (and so far it outperforms both mysql and sphinx/lucene :P).

Try to limit your queries down as much as possible in order to find what will cause the slowdowns. In my case its because I sort by date before I return the top 200 matches back to the client. Without the sort by date the search is still slow but the main slowdown is my "ORDER BY datecol".