data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
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/
:-(
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
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
Last edited by RoboPhung; 14 Apr 2011 at 09:56 AM. Reason: Adding additional information
When I install this add-on it duplicates my document categories in ZC: s regular categories, is there a work around?
I can’t reproduce that behavior on clean Zen-Cart v1.3.9h. Which version of ZC do You have? Have You installed and other addons?
You can view QC1.7 beta on zc 1.3.9h here:
Zen Cart v1.3.9h with Query Cache
it doesn’t duplicate Documents category.
Can You share a link to the store on which it occurs?
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
Nice add on but I have one issue with this cache query.
After installing cache query and removing cache from my mozilla firefox i found the time for home page:
Parse Time: 8.161 - Number of Queries: 485 - Query Time: 1.05650873018
This is really high parse time.
Without Cache query I get:
Parse Time: 1.161 - Number of Queries: 587 - Query Time: 1.05650873018
Now with cache query if i open next page I get almost half number of queries which is a best job done by Cache query.
I'm little confuse about why does the time increases to very high if i remove all caches from mozilla firefox and then open any page but subsequent page opens at very low parse time.
What should I do in that case?
Where does QueryCache store its cache ? In a file ?
For how long is the result of a select query cached ?
Can this be made to work with something like APC or memcache?
Update for Zencart 1.5 please ????
Contemplating the 1.39 -> 1.5 upgrade, but am not clear if QueryCache works fully, or partly, or not at all with ZC v1.5. The lack of chatter on this, given the large number of users of the mod, suggests it works at least in part. Can anyone confirm?
Regards
Bookmarks