MySQL Forums
Forum List  »  Performance

Re: Using 'Order By' disables use of index
Posted by: Christian Lehmann
Date: January 13, 2005 02:17PM

Hi,

i have nearly the same problem with fulltext search.
If i use SELECT * FROM fmetaangebot_new WHERE spalte='5' AND MATCH (volltext) AGAINST ('marketing' IN BOOLEAN MODE) ORDER BY datum_eintrag LIMIT 0,5
mysql uses filesort.

If i use the same query without the order by part it is very fast (0.0018 sek) against ~7.0 sek !
I have 200.000 Entries and about 60.000 results with "marketing". Therefore Filesort takes so lang and my results are to slow for web-usage. How can i prevent mysql to use FILESORT ?
Or are there other ways to improve performance ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Using 'Order By' disables use of index
1743
January 13, 2005 02:17PM


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.