Re: [PHP-DB] Caching query results in html pages

2007-03-14 Thread Chris
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 se

Re: [PHP-DB] Caching query results in html pages

2007-03-14 Thread Amit Patel
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

Re: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Micah Stevens
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 sc

RE: [PHP-DB] Caching query results in html pages

2007-03-13 Thread Bastien Koert
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