Query Cache v1.0

[data_digger]

Hello,

This is my first official contribution.

I've created Query Cache contribution that might help improve performance of Zen Cart. It prevents Zen Cart from executing the same queries many times, which can speed up Your store. I tested it on few stores and it usually reduces number of queries from 30% to 60%. Installation instructions and contribution can be found here:
http://www.data-diggers.com/query-cache
There's also screencast showing how to install this module. Please let me know what You think about it. In case of any issues please contact me via pm or via email ([email protected])

Note: there will be new version of this module, which will further reduce number of queries sent to MySQL.

[Marg]

Thank You!
Amazing results! From 1060 down to 472 on one of my sites...

[data_digger]

Happy to hear that:)
If You've found any bugs or have any suggestions please write and I'll try to fix bugs/implement new features.

[wastaboo]

Thank you i got a 60% nice job

[data_digger]

New version of Query Cache is available. In nutshell, it reduces query count by 80% ( v1.0 reduces query count by about 50%, so it's huge improvement). Results on Zen Cart Demo Store:

• without Query Cache: 950+ queries
• with Query Cache v1.5: about 200 queries

Download updated version here. Read my updated blog to find out more.

[evan70]

nice JOB work great at test site http://shop.kafeshop.cz ThnkZ

[4thwave]

Hello,
I installed Query Cache (1.3.8a) and it did reduce the number of ueries from over a 1000 down to 226 HOWEVER!

Now the site is loading EXTREMELY slow. Instead of a 50 sec load time on a 56k it's coming in at around 1:50 sec's (I pured a new cup of coffee while I was waiting) I did perform the following and no change. http://www.j w b o o k s .org

Note: Query Cache v1.5 has feature that might slow down Your store if Your web server is very slow. In such case You can try to set QC_USE_PRODUCT_QUERY_DETECTION in includes/extra_configures/query_cache.php to FALSE.

I do think that a great deal of the problem is that I made the stupid mistake of putting my store on a secure GoDaddy server. (before ( found out how slow and overloaded their servers are) any help or suggestions would be greatly appreciated. Before I uninstall the mod. BTW I am using SImple SEO, Hover Box 3 and Reward Points. Maybe 1 or 2 of the mods will need to go as well as using some graphic compression.

[data_digger]

I've sent PM to You.

[4thwave]

Hi,
The problem was that I neglected to set the second two entries to true after I set the 'QC_USE_PRODUCT_QUERY_DETECTION' to "FALSE"

The site screams now because of your mod!!!!

Dude you rock!!!

Check this out!!!!!!!
(This is down from way over 1000!

And this is even on a GoDaddy server!


Parse Time: 3.387 - Number of Queries: 230 - Query Time: 0.34338080839539

[4thwave]

Hi Again,

After I made the changes the site was fast for awhile then it slowd way down again. I am really beginning to wonder if I am on one of GoDaddy's overloaded servers and maybe this is the problem.

I am reading up on Gzip compression and how to use hoping maybe it will help. Something has to give or I will be forced to move my site off of their hosting service.

Is there a sure way to verify that their server is the issue because when I call them they say that everything is fine and that the problem MUST be my site.

This is what I am getting now:
Parse Time: 40.772 - Number of Queries: 243 - Query Time: 3.3197158103485