MySQL Forums
Forum List  »  Full-Text Search

Re: Full text search with order by
Posted by: Apachez
Date: January 10, 2006 01:28PM

How long time will it take for you if you run it as:

select * from Table1 where match(col1) against ('some string');

?

If the above is fast you could fill a temp table (in memory) with the results from the above and then perform a second query against the temp table like:

SELECT * FROM temp1 ORDER BY col2 LIMIT 10;

Options: ReplyQuote


Subject
Views
Written By
Posted
3190
October 25, 2005 06:06PM
Re: Full text search with order by
2004
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.