On Mon, 16 Jul 2001, Benjamin Pflugmann wrote:
>
>If I understand it correctly, this is a known and fixed bug:
>
>>From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html:
>----------------------------------------------------------------------
>F.2.3 Changes in release 3.23.38
>
>[...]
> * Changed optimizer so that queries like SELECT * FROM
> table_name,table_name2 ... ORDER BY key_part1 LIMIT # will use
> index on key_part1 instead of filesort.
>[...]
>----------------------------------------------------------------------
>
>Since 3.23.30, as you said you use, MySQL has experienced a lot of
>improvement, so you may want to upgrade to the current release 3.23.39.
Very good, I'm very happy that this is fixed :-)
>Btw, it is always a good idea to upgrade to a recent version before
>reporting bugs. If that is not possible, please check the archives or
>the changes history whether the bug has been fixed meanwhile.
ups, shame on me.
I will consider this in future.
regards Gunnar
---------------------------------------------------------------------
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
