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
