Query Cache v1.0

[data_digger]

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.

[drrogera]

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.

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.

[drrogera]

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

[data_digger]

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.

Parse Time: 0.770 - Number of Queries: 140 - Query Time: 0.26794561802673 

Normally (without QC) query count would be around 500-1000.

[drrogera]

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

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.

Parse Time: 0.770 - Number of Queries: 140 - Query Time: 0.26794561802673 

Normally (without QC) query count would be around 500-1000.

[eflat]

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!

[luxurywatches]

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]

[data_digger]

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

[wipasnapa_dev]

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 ?

Any help appreciated !

[data_digger]

It seems that You haven't uploaded all files. Compare Your online store with files from distribution. Most probably You haven't uploaded

includes/classes/db/mysql/query_factory.php
includes/classes/query_cache.php