Query Cache v1.5 released
2Version 1.5 of Query Cache for Zen Cart has been released. New version reduces query count by 80% (previous version reduced query count by ‘only’ 50%). Here’s list of changes:
- 970 queries down to 198 queries ( v1.0 executed about 450 queries )
- some performance improvements to code
- includes/functions/functions_categories.php has been rewritten to use cache and prefetch data. It reduces query count by about 100 queries (it depends on number of categories in Your store)
- basic queries for product from products table (for example “select products_name, manufacturers_id from products where products_id = ’7′“) can now be rewritten to “select * from products where products_id = ’7′“. It saves about 100 queries on default Zen Cart demo store.
Download Query Cache v1.5. See updated blog entry on Query Cache for updated charts, demo stores and screencast.
Stay in touch
Just type Your address here to be notified of new versions of Query Cache (You’ll receive only updates on Query Cache). Quick info: We hate spam, Your email will not be given to anyone.
hi, I was wondering:
if i wrote code like this:
$sql = ‘select b,c,d from table’;
$result = $sql->fetch_num($sql); // i don’t know if this method exists in zencart db class, just a hypothesis.
$b = $result[0]; $c = $result[1]; $d = $result[2];
will it be overwritten like this:
$sql = ‘select * from table’;// select a,b,c,d from table
then my varibles will be just messed up…
It doesn’t matter if You write ‘select a,b,c,d,e from table’ or ‘select * from table’.