I'm trying to speed up page generation for an ecommerce php application. The php script does lots of repetitive SELECT statements. I switched the mysql variable query_cache_type to "DEMAND" and that made a big improvement. I'm wondering if I can get even more improvement by using an additional caching system such as provided by ADODB. I'm also curious about the page caching features of PEAR. I realize that in order to make use of ADODB or caching in PEAR that I will need to modify code in my php application. Can somebody explain which method of caching generally works best? Can I expect to get much additional improvement beyond tuning mysql caching? The load on my server is pretty light and it is mysql which is the bottleneck due to the large number of queries required for each page generated by the ecommerce application.
