Re: Full text search with order by

[Apachez]

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;