Re: Using 'Order By' disables use of index
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 ?
Subject
Views
Written By
Posted
11333
January 07, 2005 04:17PM
5083
January 08, 2005 11:38AM
3089
January 10, 2005 08:09AM
2512
January 10, 2005 06:47PM
1918
January 11, 2005 09:58AM
2025
January 11, 2005 07:37PM
1990
December 10, 2007 06:11AM
1829
March 29, 2005 07:53AM
Re: Using 'Order By' disables use of index
1743
January 13, 2005 02:17PM
1904
March 29, 2005 07:45AM
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.