Query Cache v1.0

[dionidis]

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]

Does anybody have any ideas how to enable Query Cache and UTF-8 support?

Your solution does not work?

[data_digger]

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.

[purelypoultry]

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.

[s_p_ike]

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!

[data_digger]

Now I decided to put QC_USE_PRODUCT_QUERY_DETECTION false and things started goingi really well!

Yep, as stated in read me file (You've read it, right? ) You should check if this switch speeds up or slows down Your site.

Thank you data_digger!

Thanks for feedback.

[data_digger]

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.