Re: myisamchk sorting records descending

[JJWR]

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.