Query Cache v1.0

[fergusmacdonald]

Hi there,

I have this mod installed in my store and am wondering if anyone has some information on its compatibility with 1.3.9c before I attempt an upgrade.

Any help much appreciated.

[tony_sar]

Hi there,

I have this mod installed in my store and am wondering if anyone has some information on its compatibility with 1.3.9c before I attempt an upgrade.

Any help much appreciated.

i don't think this would be compatible with 139a,b,c,d , as query_factory.php has been changed in new releases .

[lat9]

i don't think this would be compatible with 139a,b,c,d , as query_factory.php has been changed in new releases .

You're right ... there were changes to both query_factory.php and functions_categories between zc1.3.8a and 1.3.9c. The attached zip-file has the merged version that combines Query Cache v1.6 and the respective files from ZC 1.3.9c; there is no directory structure in the zip-file, so you need to copy the files to:

/includes/classes/db/mysql/query_factory.php
/includes/functions/functions_categories.php

[mdegrandis]

Anybody get this working in 1.3.9d? I tried it, and it doesn't break the cart, but it also does not lower queries.

It is a fresh install that I used my custom template from 1.3.8a.
Mod wise it has IH2.
It has php 5.2.11 and mysq 5.0.90

Tried running it with query log as well. This is the output:

QUERY DEBUG: Requested execution of: 0 queries. Executed: 7073 queries. Returned from cache: -7073 queries.

SUM: 0


Thanks!

[Dan123]

Hi all, first of all thanks for this great module!!!
I have a question, I found that I have 2 queries that are pretty slow. the first one is caused by my SSU module, when I checked ssu_cache table, it has more than 100,000 rows. And the second one is whoisonline. Did anybody else have this issue and knows how to fix it????
Thank you!!!!!

[data_digger]

Hi all, first of all thanks for this great module!!!
I have a question, I found that I have 2 queries that are pretty slow. the first one is caused by my SSU module, when I checked ssu_cache table, it has more than 100,000 rows. And the second one is whoisonline. Did anybody else have this issue and knows how to fix it????
Thank you!!!!!

I highly recommend changing storage engine of whos_online table to InnoDB. You'll avoid locking issues with this table (it's updated on EVERY request).

[Cindy2010]

I tried that, it reduced the number of queries, but looks like the parse time is still high, especiall on the first hit (where there is no hit to my site in the previous 15 mins or so), it can be as high as 10+ seconds:

http://www.kingoflaptops.com/

:-(

[RoboPhung]

OMG Thank you for this!!!

I was getting hit with fastcgi timeouts during the checkout process because my sql queries were taking too long when customers had a lot of items in the cart, and sure enough when I turned on page parse time logging, I was showing in excess of 30,000 queries during checkout.

I was struggling with a solution and almost had to consider a vps to possibly help with the parse times.

Your addon reduced it to less than 3,000!!! It performs even better than your claim of 80% reduction! Now I don't even need to consider moving servers. I can't thank you enough for this addon!

Oh and btw I'm using your beta version, and I'm on zencart v1.3.9h

[dw08gm]

You're right ... there were changes to both query_factory.php and functions_categories between zc1.3.8a and 1.3.9c. The attached zip-file has the merged version that combines Query Cache v1.6 and the respective files from ZC 1.3.9c; there is no directory structure in the zip-file, so you need to copy the files to:

/includes/classes/db/mysql/query_factory.php
/includes/functions/functions_categories.php

Hi all

I am getting bucket loads (around one per query) of the following error messages with the above updates.

[07-Jul-2010 08:36:33] PHP Warning: mysql_data_seek() [<a href='function.mysql-data-seek'>function.mysql-data-seek</a>]: Offset 0 is invalid for MySQL result index 395 (or the query data is unbuffered) in ...\includes\classes\query_cache.php on line 38

After having tried so many combinations of the switches, I have run out of ideas how to fix.

[qrhuang728]

I really appreciate your good work on QueryCache, I have read your code and want to apply in my website, but there is one thing I need to know before:
In your code,you check the existing of Cache objects, if exists, return directly, if not exists, query from database and then return. but when cache create and things changed, how can I init all the things so that it can read all the things from database again? just like SEO cache.