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
7032
April 12, 2005 01:19AM
3254
April 25, 2005 02:44AM
Re: myisamchk sorting records descending
3287
April 26, 2005 12:50AM
3079
April 27, 2005 01:12AM
4517
May 18, 2005 02:19AM
4415
May 19, 2005 01:03AM
2972
May 19, 2005 02:22AM
3000
April 28, 2005 08:21AM
2889
May 04, 2005 05:24PM
3559
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.