[PHP-DB] query is returning over 74,000 results and taking 30 seconds - HELP!

[Aaron Wolski]

Hi Guys,
 
I've tried several different things with the following 2 queries but
nothing seem to help. I've stared at the code and reworked it for hours
on end and frankly I am getting frustrated.
 
I'm only posting the queries themselves without the PHP code as the
entire section is quite long. If someone wants it I'd be more than happy
to post it as well.
 
ANY help or guidance is very much appreciated. I'm so far beyond
frustrated it isn't funny :-(
 
Thanks in advance.
 
Aaron
 
 
CODE:
 
 
$mQuery = db_query("SELECT DISTINCT manufacturer FROM kcs_threads ORDER
BY manufacturer");
while ($mResult = db_fetch($mQuery)) {
 
                //HTMl here
 
                $query = "select t.type, t.newUrlType, g.threadType,
g.groupName, g.groupNameUrl
                FROM kcs_threads t LEFT JOIN kcs_threadgroups g ON
t.type = g.threadType
                WHERE t.manufacturer =
".escapeQuote($mResult['manufacturer'])."
                ORDER BY t.type, g.groupName";
 
                $result = db_query($query);
 
                while($thread = db_fetch($result)) {
 
                                //If validations and HTML display here
 
                }
}
 


Advertising