Re: [PHP-DB] Caching query results in html pages
I believe a much better solution would be to use MySQL Query Cache.
http://dev.mysql.com/doc/refman/5.0/en/query-cache.html
Use it wisely and there is a lot of performance gain. Donot simply enable
cache for all sql statements.
Amit.
On 3/13/07, Micah Stevens [EMAIL PROTECTED] wrote:
This may work, although I just made it up. I can see already that you'd
have some problems with multiple scripts running at once. If a script
opens the cache, then a second script saves new cache information before
the first script saves it's data, the first script would overwrite the
second script's update.
Maybe instead of a read at the beginning of script execution, a read at
the beginning of each query would be better?
Save cache results to a file:
?
// script start
$querycache = unserialize(file_get_contents(query.cache));
/*
$querycache format:
array('sql' = array(), 'result'=array(), 'time'=array());
For each sql statement 'sql' you have a result array.
*/
// run all your queries through a function:
function query($sql) {
$cached = array_search($sql, $querycache['sql'])
// check to see if the result is old
if (time() - $querycache['time'][$cached] $max_time) {
unset($querycache['time'][$cached]);
unset($querycache['sql'][$cached]);
unset($querycache['result'][$cached]);
$cached = false;
}
if ($cached) {
return $querycache['result'][$cached];
} else {
$result = mysql_query($sql);
$querycache['sql'][] = $sql;
$index = array_search($querycache['sql']);
$querycache['time'][$index] = time();
while ($r = assoc($result)) {
$querycache['result'][$index][] = $r;
}
// save cache for other scripts
file_put_contents('query.cache', serialize($querycache));
return $querycache['result'][$index];
}
}
... It's actually kind of a complicated process now that I'm thinking
about it.
-Micah
On 03/13/2007 06:20 AM, Vincent wrote:
Hi all,
I'm trying to improve the performance for visitors, and I want to know
if there is some way to store the mySQL results of .php scripts in
webpages.
So, in example, when requesting
http://www.mydomain.com/script.php?id=110 , it can be redirected to
his cached version http://www.mydomain.com/id110.html.
Any code or information would be appreciated,
Regards,
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Caching query results in html pages
Amit Patel wrote: I believe a much better solution would be to use MySQL Query Cache. http://dev.mysql.com/doc/refman/5.0/en/query-cache.html Use it wisely and there is a lot of performance gain. Donot simply enable cache for all sql statements. Maybe if you have complete control over the server you can do this. If you're on a shared host, you have no hope - anyone else's queries can knock yours out of the cache and you're back to square 1. Depending on the queries (and whether they are indexed or not) it might not even be worth worrying about attempting to cache - it all depends on the application really (whether the queries are needed, how it handles the results etc). -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Caching query results in html pages
Hi all, I'm trying to improve the performance for visitors, and I want to know if there is some way to store the mySQL results of .php scripts in webpages. So, in example, when requesting http://www.mydomain.com/script.php?id=110 , it can be redirected to his cached version http://www.mydomain.com/id110.html. Any code or information would be appreciated, Regards, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Caching query results in html pages
you can write an html page on the fly and save that to the hard drive have a look at fopen/fwrite etc bastien From: Vincent [EMAIL PROTECTED] Reply-To: Vicente [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Caching query results in html pages Date: Tue, 13 Mar 2007 14:20:58 +0100 Hi all, I'm trying to improve the performance for visitors, and I want to know if there is some way to store the mySQL results of .php scripts in webpages. So, in example, when requesting http://www.mydomain.com/script.php?id=110 , it can be redirected to his cached version http://www.mydomain.com/id110.html. Any code or information would be appreciated, Regards, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Dont waste time standing in linetry shopping online. Visit Sympatico / MSN Shopping today! http://shopping.sympatico.msn.ca -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re[2]: [PHP-DB] Caching query results in html pages
Bastien wrote: BK you can write an html page on the fly and save that to the hard drive BK have a look at fopen/fwrite etc And a more elaborated thing?. Some source development? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: Re[2]: [PHP-DB] Caching query results in html pages
http://www.weberdev.com/get_example-4082.html From: Vincent [EMAIL PROTECTED] Reply-To: Vincent [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re[2]: [PHP-DB] Caching query results in html pages Date: Tue, 13 Mar 2007 18:41:42 +0100 Bastien wrote: BK you can write an html page on the fly and save that to the hard drive BK have a look at fopen/fwrite etc And a more elaborated thing?. Some source development? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Have Some Fun Out Of The Sun This March Break http://local.live.com/?mkt=en-ca/?v=2cid=A6D6BDB4586E357F!142 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Caching query results in html pages
This may work, although I just made it up. I can see already that you'd
have some problems with multiple scripts running at once. If a script
opens the cache, then a second script saves new cache information before
the first script saves it's data, the first script would overwrite the
second script's update.
Maybe instead of a read at the beginning of script execution, a read at
the beginning of each query would be better?
Save cache results to a file:
?
// script start
$querycache = unserialize(file_get_contents(query.cache));
/*
$querycache format:
array('sql' = array(), 'result'=array(), 'time'=array());
For each sql statement 'sql' you have a result array.
*/
// run all your queries through a function:
function query($sql) {
$cached = array_search($sql, $querycache['sql'])
// check to see if the result is old
if (time() - $querycache['time'][$cached] $max_time) {
unset($querycache['time'][$cached]);
unset($querycache['sql'][$cached]);
unset($querycache['result'][$cached]);
$cached = false;
}
if ($cached) {
return $querycache['result'][$cached];
} else {
$result = mysql_query($sql);
$querycache['sql'][] = $sql;
$index = array_search($querycache['sql']);
$querycache['time'][$index] = time();
while ($r = assoc($result)) {
$querycache['result'][$index][] = $r;
}
// save cache for other scripts
file_put_contents('query.cache', serialize($querycache));
return $querycache['result'][$index];
}
}
... It's actually kind of a complicated process now that I'm thinking
about it.
-Micah
On 03/13/2007 06:20 AM, Vincent wrote:
Hi all,
I'm trying to improve the performance for visitors, and I want to know
if there is some way to store the mySQL results of .php scripts in
webpages.
So, in example, when requesting
http://www.mydomain.com/script.php?id=110 , it can be redirected to
his cached version http://www.mydomain.com/id110.html.
Any code or information would be appreciated,
Regards,
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
