Change this line:
toPHP Code:define('QC_USE_PRODUCT_QUERY_DETECTION',TRUE);
This should lower CPU usage a lot.PHP Code:define('QC_USE_PRODUCT_QUERY_DETECTION',FALSE);
Printable View
Change this line:
toPHP Code:define('QC_USE_PRODUCT_QUERY_DETECTION',TRUE);
This should lower CPU usage a lot.PHP Code:define('QC_USE_PRODUCT_QUERY_DETECTION',FALSE);
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.
OK, went through file by file and found that some files just did not install. Now they are all in and - I see data but I also see this strange box at the top of the page
"[ Close ] Match queries (regex): "
It's Find Box for Query Log. I'll try to create screencast today to show how to use it.
It seems that Query Cache is working on Your site.
Normally (without QC) query count would be around 500-1000.PHP Code:Parse Time: 0.770 - Number of Queries: 140 - Query Time: 0.26794561802673
It is working - thank you so very much. The funny thing is that I am not as interested in optimizing queries at this point as I was about seeing where my POST data was going. For some strange reason it was switching to the GET array and not coming back. Now I just test for the presence in either array and I'm good.
I suppose later I'll look at query optimization. For now, I truned teh display off since I don't need it just now.
I look forward to the next tutorial.
Roger
Quote:
Originally Posted by data_digger
Nice. Had one page go from 1813 queries to 262! I think it was so high because of a mod I have on that page. I'm on shared hosting so hopefully the cpu utilization won't be a problem, but I'll keep an eye on it. Thanks much for this!
Query Cache v1.6 can't install
1017 Can't find file: './hostname/zen_get_terms_to_filter.frm' (errno: 13)
in:
[select * from zen_get_terms_to_filter]
It has nothing to do with Query Cache. Most probably someone (You, Your hosting company, some of Your scripts or hacker) changed permission to ./hostname/zen_get_terms_to_filter.frm and possibly other files. Check that MySQL has privilages to access the file (read/write).Quote:
Originally Posted by luxurywatches
Hi,
Im running zencart 1.3.8 .
Here are the parse times,
On localhost :
Before installing this Add-on
Parse Time: 0.721 - Number of Queries: 1574 - Query Time: 0.330065291428
After Installing the Add-on
Parse Time: 0.511 - Number of Queries: 370 - Query Time: 0.228095473282
On centralized Test machine ( higher load/more users/larger db)
Before installing this Add-on
Parse Time: 1.781 - Number of Queries: 1443 - Query Time: 1.17740702115
After Installing the Add-on
Parse Time: 2.140 - Number of Queries: 1426 - Query Time: 1.54411397633
Parse Time: 1.766 - Number of Queries: 1426 - Query Time: 1.21343658868
As you can see, localhost shows the drastic improvement but the centralized testing server shows negligible improvements.
I tried setting all combinations of QC_USE_PRODUCT_QUERY_DETECTION and
QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH but to no avail.
Any idea what could be going wrong ? :frusty:
Any help appreciated !
It seems that You haven't uploaded all files. Compare Your online store with files from distribution. Most probably You haven't uploaded
PHP Code:includes/classes/db/mysql/query_factory.php
includes/classes/query_cache.php