Query Cache v1.0

[2004g35]

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

[ShoesBuyOnline]

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!

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

[ShoesBuyOnline]

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!

Hi,
I found the author have given some tips to deal this problem on http://www.data-diggers.com/query-ca...sed#comment-34

[kburner]

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

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

[data_digger]

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.

[lankeeyankee]

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!

[shartlesville]

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%.

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.

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

Thank you!

Blessings,
Krisann

[data_digger]

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.

[shartlesville]

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