New version of Query Cache is available. If You have lots of categories in Your store, this release is a must. Download new version here. Version 1.6 adds following features:
- Option to prefetch products_to_categories table for faster execution of zen_get_categories_products_list() function. You can turn ON/OFF this functionality by changing QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH switch in includes/extra_configures/query_cache.php. If Your store executes thousands of queries it’s pretty good chance that this option will solve it.
- Query Cache can now work in Admin area too. Just enable QC_ENABLE_IN_ADMIN in admin/includes//extra_configures/query_cache.php.
By default new switches are set to false. If You have many (at least few hundreds) products linked to many categories prefetching products_to_categories table will probably improve performance. On one store this switch managed to reduce query count from 15 000 queries ( yes, 15 thousands queries!) to about 100 queries (99,3% less queries!).
If You’ll find any bugs, please report back.
7 Comments for Query Cache v1.6 released
Steven | February 15, 2010 at 23:42
Author comment by admin | February 16, 2010 at 10:26
Query Cache does not use file based caching and does not store anything in cache/ folder. I’m not quite sure but I think it’s impossible to limit Zen Carts own cache. There are other cache solutions for Zen Cart – do You use any of them?
David | March 9, 2010 at 21:31
Is there a way to ‘turn off’ Query Cache easily instead of deleting and re-installing files. Want to compare differences in performance with and w/o Query Cache.
Author comment by admin | March 10, 2010 at 12:51
No, unfortunately there isn’t any switch. If You want to turn off query cache edit includes/auto_loaders/config.query_cache.php and comment the line:
‘className’=>’QueryCache’,
‘objectName’=>’queryCache’,
‘checkInstantiated’=>true);
Make also sure to turn off all switches in includes/extra_configuration/query_cache.php
Isaac | April 2, 2010 at 18:05
I am wondering if anybody else is having problem with their site when QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH is set to TRUE. It doesn’t work for us when we have category level greater than 2.
Author comment by admin | April 3, 2010 at 17:15
I checked QC 1.6 and it works on multi level categories. I can’t tell for sure but I think it’s because QueryCache tries to prefetch part of products_to_categories table and it does not fit in server memory. If You have test site with copy of the store and You can give temporary access to it to me I can check what is the problem and develop patch specific to Your site.
Isaac | May 11, 2010 at 05:35
Any plan to upgrade this for Zen Cart 1.3.9b since the two core files touched by this more are updated in 1.3.9b.
How do I limit the size of the cache dir, it seems to be getting massive