Re: 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/