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.
Subject
Views
Written By
Posted
7112
April 12, 2005 01:19AM
3305
April 25, 2005 02:44AM
Re: myisamchk sorting records descending
3342
April 26, 2005 12:50AM
3128
April 27, 2005 01:12AM
4588
May 18, 2005 02:19AM
4469
May 19, 2005 01:03AM
3033
May 19, 2005 02:22AM
3057
April 28, 2005 08:21AM
2929
May 04, 2005 05:24PM
3616
May 09, 2005 10:25AM
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.