table join into 3 queries and application based arrays, I
reduced the run time to about 10 seconds with 50x the output.
Bastien
From: Eddie Peloke <[EMAIL PROTECTED]>
Reply-To: Eddie Peloke <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] mysql query plan
Date: Wed, 13 Ap
Hello,
We are working to optimize a few queries. When we run the query with
Explain, it appears that the query optimizer is not using one of the
tables index and doing a full table scan while it appears to use other
tables' indices properly. We then remove the table with the full
scan, run again
