installing this module seems to have broken the encrypted master password module. any ideas on how to fix so they are compatible?
thanks
installing this module seems to have broken the encrypted master password module. any ideas on how to fix so they are compatible?
thanks
follow up. now seems entirely coincidental and unrelated.
pti.
Took my queries from over 5000 down to under 1000 so pretty dramatic loadtime difference.
THANKS VERY MUCH excellent work
We are using UTF-8 and have some problems with this module.
All charachters such as ü or đ, š, ć, č and similar are now shown as some weird symbols.
We tracked the problem to this part of the module on the shop side.
If you want to enable UTF-8 support to work properly in Zen-cart you have to add this part of the code around the line 37 in file Zen-Cart\includes\classes\db\mysql\query_factory.php
if (version_compare(mysql_get_server_info(), '4.1.0', '>=')) {
mysql_query('SET NAMES "utf8"', $this->link);}/* Changes for UTF-8 Support*/
right after line 37
if (@mysql_select_db($zf_database, $this->link)) {
Does anybody have any ideas how to enable Query Cache and UTF-8 support?
Thank you very much for your supoort and this great module!
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
I promised to release new, more memory efficient version of Query Cache soon – unfortunately (or fortunately) it seems that PHP is quite good at managing memory and there’s not much to improve. Therefore version 1.7 of Query Cache will be delayed.
Request to Query Cache users:
If You use Query Cache and Your store is still slow and it’s not related to search script please contact me either on email, PM on Zen-Cart.com (data_digger) or by leaving comment. I’ll check Your site and try to make necessary changes in Query Cache v1.7 for You.
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
Ah I get it now. 1.7 is not out yet. I saw your website and was confused.
I will install this when I get home.
Owner of Purely Poultry
Hello,
I just installed your script. I had problems with attributes, as well known.
Situation:
This site is on a cloud hosting, so resources are not really a block. Remaining inside some range (that we may increase if needed whenever we want, in real time), we may 'move' resources a bit around and since it's cloud, it use resources as needed.
But of course there are some limits (and we didn't anything atm to investigate how is possibile to better tune mysql for example).
Well, I put some products with some attributes in the cart, obtaining these results:
Before query cache
Home page
query: 1156 query time: 0,3294 Parse time: 0,6650
Cart page (I already worked a bit on attributes flags to lower # of queries from around 13000 to 6600)
query: 6662 query time: 1,6375 Parse time: 2,3140
After query cache
Home page
query: 234 query time: 0,3178 Parse time: 0,5960
Cart page
query: 340 query time: 1,3861 Parse time: 2,0980
Consideration: in cart page we had a cut of 95% in # of queries. That's really great! More, that's incredible.
Unfortuntaley performances didn't improve so much (some test gave even worst results).
I tried checking server resources usage charts and it seems (a bit too early to see well on the chart) that we had a growth in memory and cpu usage (we already stress a bit cpu with url rewrite and other htaccess rules for performance gaining moving load from bandwidth to cpu).
Now I decided to put QC_USE_PRODUCT_QUERY_DETECTION false and things started goingi really well!
Home page
query: 285 query time: 0,1769 Parse time: 0,460
Cart page
query: 380 query time: 0,5018 Parse time: 1,0980
A bit increase of # of queries (irrilevant, but strange as you stated)
Good values for the situation. A bit strange that without this mod query time to execute 300 queries is something like 0,03 but with this mod, it becomes 0.17 / 0.5 (strange but sure it is so, since I made many reloads).
Results: this mod is great. Even in cloud hosting where ther's not a real block, we gained seconds. For us it's not a matter of server resources but user satisfaction. Now we'll work on parse time (I found an awfully made template...)
Thank you data_digger!
Last edited by s_p_ike; 2 Mar 2010 at 04:58 PM.
Paolo De Dionigi
Co-maintainer of Zen Cart Italia
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
By the way, shopping cart page needs serious rewriting. It seems that the more distinct products customer adds to shopping cart the more time it takes to load the page. As far as I observed time to generate shopping cart page grows linearly by quite large factor with number of distinct products in shopping cart. With 20 products in shopping cart (not so uncommon in some sorts of online stores) it usually takes 4-8 sec to generate shopping cart page.
data_digger,
Query Cache v1.7-beta for ZC 1.3.9h Reduce query count by 80% | Randomized Tests
www.data-diggers.com
Bookmarks