MySQL Forums
Forum List  »  MyISAM

Re: myisamchk sorting records descending
Posted by: Ulf Wendel
Date: May 19, 2005 02:22AM

JJWR wrote:
> Ulf what I want to do is to sort the rows
> physically descending in the disk. This is to
> avoid the 'order by filed DESC' en the querys and
> to take profit of the LIMIT clause.

Ok, got it. That's not possible.

The only optimization that you could get is fetching the order from the index. This will help to avoid sorting. But as you explain later, this does not solve your disk-head jumping / disk-seek problem, you won't get sequential reads.

Ulf

Options: ReplyQuote


Subject
Views
Written By
Posted
6865
April 12, 2005 01:19AM
3206
April 26, 2005 12:50AM
Re: myisamchk sorting records descending
2875
May 19, 2005 02:22AM
2897
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.