Query Cache v1.0

[data_digger]

By the way, sorry folks for lack of support for past two months. I had very little spare time.

[data_digger]

Does anyone know how I can UNINSTALL this plugin???

If You just installed Query Cache (without Query Log) delete all files that are present in .zip package. You'll have to upload to Your store files from original Zen Cart distribution:

• includes/classes/db/mysql/query_factory.php
• admin/includes/classes/db/mysql/query_factory.php

I never had to uninstall Query Cache, so.. backup ;)

[kelvyn]

By the way, sorry folks for lack of support for past two months. I had very little spare time.

No problem - I only just discovered this contribution and it's made a BIG difference to store speed. Thanks very much - a very easy contribution to install and use!

[kburner]

My site seems slow. So, I wanted to see parse time. I went to admin/conf/display parse time and turned to true. But does not show up when I go to my site at bottom of page. Is there something else I need to do?

Thanks, Kim

[data_digger]

My site seems slow. So, I wanted to see parse time. I went to admin/conf/display parse time and turned to true. But does not show up when I go to my site at bottom of page. Is there something else I need to do?

It should work. In fact, I see page parse times/query count on Your website (http://www.burnerbooks.com/).

[kburner]

It should work. In fact, I see page parse times/query count on Your website (http://www.burnerbooks.com/).

Yes, I found it and loaded Query Cache

went from:
Parse Time: 1.155 - Number of Queries: 1543 - Query Time: .35931

to:
Parse Time: 0.942 - Number of Queries: 521 - Query Time: 0.182910085205

If I am understanding it correctly with relation to speed (load time) I am very happy!

Works Great!
Thanks, Kim

[data_digger]

Yes, I found it and loaded Query Cache

went from:
Parse Time: 1.155 - Number of Queries: 1543 - Query Time: .35931

to:
Parse Time: 0.942 - Number of Queries: 521 - Query Time: 0.182910085205

If I am understanding it correctly with relation to speed (load time) I am very happy!

Works Great!
Thanks, Kim

It's not that big improvement, besides some of Your pages take way to much time to load - about 3 seconds (search/category view). Unfortunately Query Cache can't help here, You would have to rewrite some queries in index.php / advanced_search_results.php to get better performance.

Take closer look on right column, it takes noticeable amount of time to generate. You can turn on/off each box and check which one is slowing things down.

[kburner]

It's not that big improvement, besides some of Your pages take way to much time to load - about 3 seconds (search/category view). Unfortunately Query Cache can't help here, You would have to rewrite some queries in index.php / advanced_search_results.php to get better performance.

Take closer look on right column, it takes noticeable amount of time to generate. You can turn on/off each box and check which one is slowing things down.

My big hitter is the livehelp. It is slowing things down. How do I fix?
Thanks, Kim

[kelvyn]

WARNING: There is a conflict between Query Cache 1.6 (download / official forum / zen support thread) and Google Base Feeder ( download / official forum / zen support thread )

It took quite a few hours as well as support tickets to my host who gave up in the end! But starting from a clean install this morning, and putting things back one by one, I've arrived at the answer this afternoon :)

Anyway, when Query Cache is installed, and when trying to generate a product feed for Google, the error is:

Google Base Feeder v1.7.4 started 2009/05/06 01:04:05
Feed file - /home/xxx/public_html/party-store/feed/frolic_base_products.xml
Processing: Feed - Yes, Upload - No
0 
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '3820' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '6937d0f20ee9cbdec967fbc59e8ff2a0']

and sometimes it also says:
2008 MySQL client ran out of memory

Given that Query Cache is so good for the customer side, is it OK just to either remove it from the admin side, or somehow tell the Google Froogle (Base) feeder no to use it?
Thanks!

[kburner]

WARNING: There is a conflict between Query Cache 1.6 (download / official forum / zen support thread) and Google Base Feeder ( download / official forum / zen support thread )

It took quite a few hours as well as support tickets to my host who gave up in the end! But starting from a clean install this morning, and putting things back one by one, I've arrived at the answer this afternoon :)

Anyway, when Query Cache is installed, and when trying to generate a product feed for Google, the error is:

Google Base Feeder v1.7.4 started 2009/05/06 01:04:05
Feed file - /home/xxx/public_html/party-store/feed/frolic_base_products.xml
Processing: Feed - Yes, Upload - No
0 
in:
[select options_id, price_prefix, options_values_price, attributes_display_only, attributes_price_base_included from products_attributes where products_id = '3820' and attributes_display_only != '1' and attributes_price_base_included='1' and options_values_price > 0 order by options_id, price_prefix, options_values_price]
2013 Lost connection to MySQL server during query
in:
[select count(*) as total from sessions where sesskey = '6937d0f20ee9cbdec967fbc59e8ff2a0']

and sometimes it also says:
2008 MySQL client ran out of memory

Given that Query Cache is so good for the customer side, is it OK just to either remove it from the admin side, or somehow tell the Google Froogle (Base) feeder no to use it?
Thanks!

I am so glad you found this out. I have been frustrated with trying to get google base and analytics working too.
I get the same error messages. Kim