Query Cache v1.0

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

When I install this add-on it duplicates my document categories in ZC: s regular categories, is there a work around?

Soniccc:

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?

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 ???? :blush::blush::blush:

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

extrapilot:

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?

RegardsAlso wondering about this...

Can I use Query Cache with DDQuery?
Or should I remove DDQuery files before uploading Query Cache?

I had installed DDQuery before finding Query Cache and am hoping I can improve results. Or is that not so?

Thanks for this plugin and for DDQuery too.

http://www.data-diggers.com/ appears to have been hacked.
The links dont seem to be working.. Is this mod still available or does anybody have a copy they can let me have? I'm running v1.3.9h

iddy:

http://www.data-diggers.com/ appears to have been hacked.
The links dont seem to be working.. Is this mod still available or does anybody have a copy they can let me have? I'm running v1.3.9h

Please guys if anyone has the latest version for 1.3.9 zen cart upload it so that more people get it and try. Thank you in advance.

The following link is not working

http://www.data-diggers.com/contribs/query-cache/downloads/querycache-current.zip

I am also in need of the addon above.
Can anyone help me find it for 1.3.9h or does anyone know if the version I find here at this site (1.3.8) work for my version of 139h?

Maynards:

I am also in need of the addon above.
Can anyone help me find it for 1.3.9h or does anyone know if the version I find here at this site (1.3.8) work for my version of 139h?

I already installed and test the one provided here but with no luck. I use 1.3.9h too. Hope someone will upload the version for 1.3.9 mentioned above!

infogate:

I already installed and test the one provided here but with no luck. I use 1.3.9h too. Hope someone will upload the version for 1.3.9 mentioned above!

I found v1.7-beta below, which is supposed to be for 1.3.9h. However I'm not sure if this will work for 1.3.9e, which is the one I'm running, Does anyone know? Cheers!

http://www.data-diggers.com/?wpdmact=process&did=MS5ob3RsaW5r

Thank you very much for the reply.
Just installed the new version and seems everything to work perfect with 1.39h. Please be my guest and test to www.info-gate.gr

Do you know if this version will work for 1.3.9e?

ttfan:

Do you know if this version will work for 1.3.9e?

Inside the zip you will find the readme.txt. There you know exactly the files you'll override. Just backup only them and test.

I could easily say that if there is no problem with 1.3.9h and works perrfectly that it'll do the same with 1.3.9e

Ahhh, so it contains no database changes at all?

If that's the case, you're right... I can just backup the old files, overwrite them with the new ones, and try it on my 'live' site. If it does not work, I can just restore the old files.

Can someone please confirm that Query Cache does not made any modifications to the database?

Of course I'll still backup all files and the database before I make any changes, but if no database changes are made, I can very quickly just test it on my live site, and if it does not work, simply swap back the 2 files that it changes.

Thanks a lot!

ttfan:

Can someone please confirm that Query Cache does not made any modifications to the database?

Of course I'll still backup all files and the database before I make any changes, but if no database changes are made, I can very quickly just test it on my live site, and if it does not work, simply swap back the 2 files that it changes.

Thanks a lot!

Hello once again.
I have already confirmed that.
You really have nothing to be afraid of.
You can even confirm that inside the readme file of the creator.
It just replaces a few files that you can just back up.

Hope this was helpfull :smile: