Hi I Found Group By to be a bit faster...but still it takes 30 secs to execute a query... What could be done..I have Indexing on almost all the tables..
-Arul ----- Original Message ----- From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: "Arul" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 4:25 PM Subject: Re: Query Optimization > Pada Mon, 8 Jul 2002 16:07:04 +0530 > "Arul" <[EMAIL PROTECTED]> menulis : > > > Hi All > > > > The Query below took around 175 Secs to return 22 Rows..Any way this query > > can be optimized > > try to use group by instead of distinct .... i usually found group by is faster ;-) > > anyway ... performance of query is more related to : > - table definition > - indexing > - mysql parameter values > - OS and hardware spec/limitation > > -- > Let's call it an accidental feature. > -- Larry Wall > > MySQL 3.23.51 : up 17 days, Queries : 365.147 per second (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