MySQL Forums
Forum List  »  Full-Text Search

Re: Some fulltext queries hang miserably
Posted by: Apachez
Date: May 02, 2006 01:12PM

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".

Options: ReplyQuote

Written By
Re: Some fulltext queries hang miserably
May 02, 2006 01:12PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.