MySQL Forums
Forum List  »  Full-Text Search

Full text search with order by
Posted by: Berry Crawford
Date: October 25, 2005 06:06PM

Im fairly new to MySQL and I have a problem. I am finding full text searchinmg dreadfully slow when I need to do an order by.

For example a query like:

select * from Table1 where match(col1) against ('some string') order by col2 limit 10;

This type of query is taking 25 seconds with a table that has 3.5 million rows. Is there anything pbvious I could do to speed this up?

Options: ReplyQuote

Written By
Full text search with order by
October 25, 2005 06:06PM
January 10, 2006 01:28PM

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.