John, You made one comment which is caught my attention:
> that's a no go :( Or is there a way of storing common query results? If the results to a commonly called query are the same for a time period, than why don't you right a routine that just stores the results into a new database that also has a results_expired field. Then, everytime the results are request, you can write a function which checks to see if the results are still valid, if they are, it displays them, if not, it requeries... i.e. function getresults($common_query) { $query="SELECT results,TIMESTAMP(expired) as dt_expired FROM storedqueries WHERE query=$common_query"; $results=mysql_fetch_object(mysql_query($query)) or error_handler(); if($results->expired <=time()) { //rebuild long slow query and exectue it so that $results has the result of the new query and $query is the query $update_query="INSERT INTO storedqueryies (query,results,expired) VALUES ($query,$results->results,[expired_time) mysql_query($update_query) or error_handler(); } return $results->results; } -----Original Message----- From: John Holmes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 6:49 PM To: 'Richard Baskett'; 'PHP General' Subject: RE: [PHP] Speeding up PHP or MySQL > Is there anyways to speed up MySQL queries? Or showing the results > through PHP? I have several queries that have about 8 left joins or > so.. Yes very > huge and when you have lots of people using these functions at once it > really slows down.. Are there any practices that you can think of that > would speed up any sql queries? I was thinking of using stored > procedures, but > after a bit of research I found ou= t that MySQL doesn=B9t have that yet > so > that's a no go :( Or is there a way of storing common query results? I > am > looking for _anything_ that will speed up showing results to large > queries.. How about an index on your tables? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php