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 ----- Original Message ----- From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, January 18, 2002 3:57 PM Subject: Re: Why does DISTINCT take so long time ?? > Fournier Jocelyn [Presence-PC] writes: > > Hi, > > > > I've notice sometimes DISTINCT clause take a really high amount of time to > > remove duplicates whereas it should be really quick (I assume it should be > > ;)) > > > > [skip] > > > > > Why does it take so much time to remove duplicates in only 58 rows ?? > > > > Thank you :) > > > > Regards, > > > > Jocelyn Fournier > > Presence-PC > > > > > Hi! > > Because it has to make first a temporary table with 2 million rows. > > And is it 4.0.1 ? > > -- > 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