MySQL Forums
Forum List  »  MyISAM

Re: myisamchk sorting records descending
Posted by: JJWR
Date: April 26, 2005 12:50AM

I have to sort descending a long number of records and I can't use a key sorting because the query is a full text search query, So currently I do "select * from table where match(field) against('+word' IN BOOLEAN MODE) order by mysortfiledkey desc limit 0,50"

if i had the records already sorted descending in the disk I would avoid the "order by" clause and do "select * from table where match(filed) against('+word' IN BOOLEAN MODE) limit 0,50" which avoids the order by and also the where clause is much faster.

Options: ReplyQuote


Subject
Views
Written By
Posted
7032
April 12, 2005 01:19AM
Re: myisamchk sorting records descending
3287
April 26, 2005 12:50AM
3000
April 28, 2005 08:21AM


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.