By the way, sorry folks for lack of support for past two months. I had very little spare time.
Printable View
By the way, sorry folks for lack of support for past two months. I had very little spare time.
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:Quote:
Originally Posted by pseudonym
- includes/classes/db/mysql/query_factory.php
- admin/includes/classes/db/mysql/query_factory.php
I never had to uninstall Query Cache, so.. backup ;)
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!Quote:
Originally Posted by 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?
Thanks, Kim
It should work. In fact, I see page parse times/query count on Your website (http://www.burnerbooks.com/).Quote:
Originally Posted by kburner
Yes, I found it and loaded Query CacheQuote:
Originally Posted by data_digger
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.Quote:
Originally Posted by kburner
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?Quote:
Originally Posted by data_digger
Thanks, Kim
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:
and sometimes it also says:Code: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!
I am so glad you found this out. I have been frustrated with trying to get google base and analytics working too.:frusty:Quote:
Originally Posted by kelvyn
I get the same error messages. Kim