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).Quote:
Originally Posted by Dan123
Printable View
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).Quote:
Originally Posted by Dan123
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/
:-(
Can You check if query time is also high? What times do You get? PM me as it's most probably not related to QueryCache and We shouldn't continue the discussion here.Quote:
Originally Posted by Cindy2010
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?
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?Quote:
Originally Posted by Soniccc
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
Also wondering about this...Quote:
Originally Posted by extrapilot
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
Quote:
Originally Posted by iddy
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...he-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?
Quote:
Originally Posted by Maynards
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!Quote:
Originally Posted by infogate
http://www.data-diggers.com/?wpdmact...d=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?
Quote:
Originally Posted by ttfan
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!
Quote:
Originally Posted by ttfan
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:
THanks again for you help!
It seems to work well... a lot less queries, although I'm not quite sure if the Parse time has improved much... perhaps when the server is busy the improvement will be much more obvious.
Hello Everyone ,
Is this module still useful and compatible with v.1.5.0 also ?
Thank you very much !
It's built-in to v1.5.1
Hello, Everyone,
I installed the plugin in my website. It seems quite good and reduce many sql query.
without Query Cache: 2000+ queries
with Query Cache v1.6: about 500 queries
But it seems having a bug. My website in browser will show following wrong code when I upload a product to my store.
1062 Duplicate entry 'ca34fbe5f9a075091ad59abf02c259a7-1' for key 1
in:
[INSERT INTO seo_cache (cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires) VALUES ('ca34fbe5f9a075091ad59abf02c259a7', '1', 'seo_urls_v2_products', /GbVE6QO7VPWmV2X+v2B7jb8RuacilmdVghNzVjNS1US7i1Pn/PhT/K4j2YLH6jlv7iYbBhjD6abt5uZMCymyYs0Bzt/wc=', '1', '1', 'EVAL', '2013-03-26 03:27:49', '2013-04-25 03:27:49')]
The above wrong code only shows one time on browser, after I upload a new product into my store. And then my website is OK if I repeat to click any page. Please anyone has ever met the same issue, or any advise regarding above wrong code. Thank you in advance.
Quote:
Originally Posted by Eric Chen
Witch is the Zen Cart version you are using query cache?
The Zen Cart version is 1.3.8a. Thank you.Quote:
Originally Posted by infogate
I suggest unistall V1.7 cause it is tested and works fro 1.3.9 installations and try an older version like 1.6 or 1.6.1.Quote:
Originally Posted by Eric Chen
The other option is to update zencart installation :)
If you're not upgrading for awhile, a good idea is to try one of the following tips ---> http://www.data-diggers.com/advanced...formance-tips/
Remember before any change!!! Backup to be able to go back!
The query cache in my v1.5.1 does not seem to be working.Quote:
Originally Posted by DrByte
For example on the same product, my test v1.5.1 showed
Parse Time: 5.188 - Number of Queries: 699 - Query Time: 3.60574690321.
My v1.3.9h showed
Parse Time: 1.840 - Number of Queries: 102 - Query Time: 0.152396841141.
When installing v1.5.1, I chose File under SQL Cache Method. I have not moved the cache file above the Zencart folder yet.
Is there something else that we are suppose to do to make the Query Cache work like it did in the v1.3.9h?
Your server seems rather slow (database for sure, also the PHP code) - you may want to look into the performance of your hosting / testing environment.Quote:
Originally Posted by katrobb
Results from a clean installation of ZC 1.5.1 w/ the SQL_CACHE_METHOD patch and the USU plugin:
ZC 1.5.1 (Query Cache: off, SQL_CACHE_METHOD: none): Parse Time: 0.507 - Number of Queries: 831 - Query Time: 0.22103139341736
ZC 1.5.1 (Query Cache: on, SQL_CACHE_METHOD: none): Parse Time: 0.470 - Number of Queries: 402 - Query Time: 0.19609870233154
ZC 1.5.1 (Query Cache: on, SQL_CACHE_METHOD: file): Parse Time: 0.419 - Number of Queries: 376 - Query Time: 0.16558531408692
NOTE: Using "test data", default settings (including EZ-Pages and sideboxes), and accessing the product page for "Matrox G200 MMS" (two attributes). Zen Cart is running on a LAMP VM (Core2 VCPU limited to 20-50% of a single core w/ 512G mem). LAMP VM is running Apache mpm-prefork + PHP 5.4 + MySQL 5.5. Same VM is also running multiple other websites (and other web applications). QC was disabled for tests by commenting out the appropriate auto loader lines.
As you can see the Query Cache does have an effect. Note using the SQL_CACHE_METHOD only affects a VERY small number of queries (ones which have potential to be slow) - thus the small impact enabling this option had in my test environment. But yes there are a few differences between QC 1.6/1.7B and the QC included in Zen Cart 1.5.1.
If I remember correctly (it has been awhile since I looked at QC 1.6/1.7B), QC 1.6/1.7B added changes to Zen Cart which resulted in the category and product name/id/parent mappings being read into memory early on and then using functions to return these where Zen Cart needed this information. This is done at the expense of additional memory being required by each page request.
The Zen Cart 1.5.1 version of QC does not do this which results in a greater number of SQL calls overall, but reduces the amount of memory required / used by a single call to Zen Cart. This reduces the potential for the server to "run out of memory" potentially forcing additional disk I/O or "out of memory" crashes of PHP.
As SQL calls are typically very fast, hosting providers often limit memory usage, and disk I/O is usually the biggest bottleneck... Having a balance between "saved SQL calls" and "memory usage" in the Zen Cart 1.5.1 version of QC makes sense. In most hosting environments were I have installed Zen Cart, making the extra 200-300 small (returned data) SQL calls instead of a few large (returned data) SQL calls does not make much difference...
However if your MySQL server is not hosted on the same server as your web server (such as a different hosting provider, in rare cases)... And there is a substantial network delay for connecting and retrieving data from the remote MySQL server... You may wish to add back in some additional caching... Or talk to your providers about why the communications are so slow...
Or better yet just make sure both the MySQL server and Web Server are on the same local network (or server) and not overloaded...
Hi, is this module on the plugin page still compatible with the latest zen cart v1.5.1?
Quote:
Originally Posted by waterbender
It's already built-in.
wonderful, thank you :)
I installed the plugin in my website. It seems quite good and reduce much sql query.
without Query Cache: 2000+ queries;
with Query Cache v1.6: about 500 queries;
But now a problem is happening. My website in browser will show following wrong code when I upload a product to my store.
1062 Duplicate entry '4404c1df54fdb1291c8dd9bb259f32a9-1' for key 1
in:
[INSERT INTO seo_cache (cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires) VALUES ('4404c1df54fdb1291c8dd9bb259f32a9', '1', 'seo_urls_v2_manufacturers', 'AwA=', '1', '1', 'EVAL', '2015-04-25 04:37:54', '2015-05-25 04:37:54')]
The above wrong code only shows one time on browser, after I upload a new product into my store. And then my website is OK if I repeat to click any page. Please anyone has ever met the same issue, or any advise regarding above wrong code.
So far, I still have not got any solution... Any advise from any buddy!!!