I understand it has to re-iterate if the number of rows in the result without DISTINCT is greater than the limit clause, but if the result without DISTINCT is lower, it should be faster to perform the DISTINCT on the result directly (or perhaps I'm missing something ? ;)). ----- Original Message ----- From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 18, 2002 4:27 PM Subject: Re: Why does DISTINCT take so long time ??
> Fournier Jocelyn [Presence-PC] writes: > > Hi, > > > > Yes it is 4.0.1. > > But the first query has also to make a temporary table with 2 million rows, > > it's why I don't understand the delta between the query without DISTINCT and > > the query with DISTINCT. > > The "remove duplicates" doesn't occurs after the join was performed ?? (it > > should be really fast in this case) > > > > Regards, > > > > Jocelyn > > DISTINCT simply has to re-iterate. > > -- > Regards, > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > <___/ www.mysql.com > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
