On Wed, Jul 25, 2001 at 12:03:59PM +0400, Artem V. Ryabov wrote:
> Hello All,
>
> When I use "order by .. DESC" in query, time always more then in
> "order by .. ASC" case.
> Explain say "Using filesort",in "DESC" case query.
>
> Why???
Because in 3.23.xx, MySQL doesn't know how to walk the index nodes
backward (in reverse order). As you know by now, this is being fixed
in the next major release.
If you need a solution before then, check the list archives. I posted
one a couple months ago...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 42 days, processed 330,961,403 queries (90/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
