Query Cache v1.0

[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

[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

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

Well, here we are a year on, has anyone had any ideas about this? What I've done now is a small script that copies the standard (works with google base feeder but inefficient) copy of query_factory over before base feeder runs, and then copies the query-cache version back.

But this doesn't seem a very elegant way of doing things, but query cache does make a BIG difference to the store speed.