Optimizing Query
| From: | Arie Nugraha | Date: | Wed, 25 Jul 2007 03:08:14 +0000 |
| Subject: | Optimizing Query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43856@lists.php.net to get a copy of this message | ||
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN mst_author AS
a ON ba.author_id=a.author_id WHERE b.biblio_id IS NOT NULL GROUP BY
b.biblio_id ORDER BY b.input_date DESC LIMIT 0, 10
it took about 6 seconds to complete the query in localhost. I already make
an Indexes on each table, but still the performance is slow.
Anyone have an idea how to optimize the query so result is faster?
Thx