Query Cache v1.0

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

pseudonym:

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 ;)

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

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?
It should work. In fact, I see page parse times/query count on Your website (http://www.burnerbooks.com/).

data_digger:

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

kburner:

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.

data_digger:

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!

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

The mod works great - now can I delete the thousands of files in my /cache and cache/fancy-data directories. These are putting me over the limit of files for my hosting service. Thanks

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']

> *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!

Frankly speaking, this add-on is impressive to me at first! But now :(. To use or not to use, it is a question! :cool:

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']

> *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!

Hi,
I found the author have given some tips to deal this problem on <http://www.data-diggers.com/query-cache-v1.6-released#comment-34>

:P

How do you turn this module off? Which file?

I can always turn it back on when a fix is in place. Right now, Google does not show my 10,000+ products.....

Thanks, Kim

I am using the latest version of query cache on 1.3.7.1. I occasionally get this error while browsing through the store side of our site:

1062 Duplicate entry 'zc_7eb4ed1f36d90140477d9474b61e0e26' for key 1
in:
[db_cache table]

Is this to do with query cache?? I hate for customers to get this error message on an otherwise blank page!!

My extra configures settings are:

define('QC_USE_PRODUCT_QUERY_DETECTION',FALSE);
define('QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH', FALSE);

lankeeyankee:

I am using the latest version of query cache on 1.3.7.1. I occasionally get this error while browsing through the store side of our site:

1062 Duplicate entry 'zc_7eb4ed1f36d90140477d9474b61e0e26' for key 1
in:
[db_cache table]

Is this to do with query cache?? I hate for customers to get this error message on an otherwise blank page!!

My extra configures settings are:

define('QC_USE_PRODUCT_QUERY_DETECTION',FALSE);
define('QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH', FALSE);
No, it's not because of QueryCache. Query Cache does not use db_cache_table.

data_digger:

No, it's not because of QueryCache. Query Cache does not use db_cache_table.

OK, thanks a lot for confirming that QC is not the issue. I don't know why it does this but it's annoying to say the least! :smile:

I would love to use this but after trying the newest version for the past few days I have received repeated warnings from my hosting company about high CPU loads. I am allowed a maximum of 6.5% and it has been as high as almost 18%. :shocking:

The parse times and query counts were great but I can't afford a dedicated server and I've already upgraded to more allotted CPU and can't afford to upgrade again. :no:

Is there a way to maintain a happy medium - to lower the times /counts without increasing the CPU by such a large amount? When running w/out QC my CPU load averages 1.5 - 3.5%.

All suggestions and advice welcome (but please don't tell me to change hosts, lol. I have to wait 11 months :lamo:).

Thank you!

Blessings,
Krisann

shartlesville:

Is there a way to maintain a happy medium - to lower the times /counts without increasing the CPU by such a large amount? When running w/out QC my CPU load averages 1.5 - 3.5%.
Paste here contents of includes/extra_configures/query_cache.php.

data_digger:

Paste here contents of includes/extra_configures/query_cache.php.

<?php
/**
 * These settings can provide great performance gains, but also can slow down
 * Your site. Make sure that turning them on improves performance of Your store.
 */
define('QC_USE_PRODUCT_QUERY_DETECTION',TRUE);
define('QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH', FALSE);
define('QC_ENABLE_IN_ADMIN', FALSE);
?>

Will changing one of these lower the CPU load?

Thank you!

Blessings,
Krisann

Change this line:

define('QC_USE_PRODUCT_QUERY_DETECTION',TRUE);

to

define('QC_USE_PRODUCT_QUERY_DETECTION',FALSE);

This should lower CPU usage a lot.

I am not sure where I went wrong but after installing both Query_Cache and Query_Logger I see no evidence that either is working or installed. :dontgetit

I did see, after running the SQL patch, that the Logging configuration options are there but I see no change in queries not do I see the queries at the bottom of the pages for my trusted account.

I really need to see what is going on and I would appreciate some assistance.
Thanks

Site http://aqsp.iqualex.com

Yes it is ugly and yes there are things that need fixing - that's why it is a test server.