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: Re[2]: [PHP-DB] Caching query results in html pages

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

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

2007-03-13 Thread Vincent
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: [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 2

[PHP-DB] Caching query results in html pages

2007-03-13 Thread Vincent
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.c