Full text search with order by

[Berry Crawford]

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?