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
