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
