Hi,
I've been using 3.23.37 source tarball compiled for Linux 2.2.19. Now I
upgraded to 3.23.39 but still the same result... Anyway, it's not that
important - I was just wondering why SELECT DISTINCT ... LIMIT is slower than
the
one without LIMIT. It's not crucial for my application and
does not prevent MySQL from being my favourite cup of database tea :)
Thanx!
George
----- изходно съобщение -----
От: Sinisa Milivojevic <[EMAIL PROTECTED]>
Тема: Re: Re: distinct / limit optimization
>X Gogo writes:
>> Well, the order in which the queries are made doesn't matter. The query
>with
>> LIMIT is always slower than the one
>> without it. When I used EXPLAIN SELECT... I actually
>> found that MySQL uses temporary table for the query with
>> the DISTINCT / LIMIT combination. I presume this slows it down.
>>
>> Be well :)
>>
>> George
>>
>
>What version of MySQL are you using ??
>
>If not the last available, give it a try.
>
>--
>Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
>/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
> <___/ www.mysql.com
----
Безплатна пощенска служба http://mail.Rambler.bg/
---------------------------------------------------------------------
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
