Query Cache v1.0

I've sent PM to You.

Hi,
The problem was that I neglected to set the second two entries to true after I set the 'QC_USE_PRODUCT_QUERY_DETECTION' to "FALSE"

The site screams now because of your mod!!!!

Dude you rock!!!

Check this out!!!!!!!:clap:
(This is down from way over 1000!

And this is even on a GoDaddy server!

Parse Time: 3.387 - Number of Queries: 230 - Query Time: 0.34338080839539

Hi Again,

After I made the changes the site was fast for awhile then it slowd way down again. I am really beginning to wonder if I am on one of GoDaddy's overloaded servers and maybe this is the problem.

I am reading up on Gzip compression and how to use hoping maybe it will help. Something has to give or I will be forced to move my site off of their hosting service.

Is there a sure way to verify that their server is the issue because when I call them they say that everything is fine and that the problem MUST be my site.

This is what I am getting now:
Parse Time: 40.772 - Number of Queries: 243 - Query Time: 3.3197158103485

Parse Time: 40.772 << regardless of what you do, this indicates an overloaded Server

Hi Rob,

My next call is to GoDaddy. If they cannot cure the issue then I will be moving my site.

Could you or someone pm me with some hosting suggestions?

Thank's Rob,

Alan

There is a list of hosting suggestions here: http://www.zen-cart.com/index.php?main_page=infopages&pages_id=10

I installed this, didn't seem to make much difference so I uninstalled it and restored the two files it overwrote, now I am getting this:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_SHOW_PRODUCT_INFO_MAIN' at line 1
in:
[SQL_SHOW_PRODUCT_INFO_MAIN]
```Can anyone help me fix this asap please?

[www.havendesignz.com/store/](http://www.havendesignz.com/store/)

Just put the store down for maintenance and have this in bottom right corner now 

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_BANNER_CHECK_QUERY' at line 1
in:
[SQL_BANNER_CHECK_QUERY]

Panic over, I accidentally deleted define_queries.php....lovely end to a very blonde day LOL

Hi again, took a break from the pc, figured since all the other posters here had really good results that it had to be a fault on my end not to get much difference the first time (I prolly missed uploading a file with my track record today LMAO), so took a break and re-uploaded LOL

Went from:

Parse Time: 1.151 - Number of Queries: 597 - Query Time: 0.0619792304688

to:

Parse Time: 1.436 - Number of Queries: 260 - Query Time: 0.320205312271

which is great! Thank you :)

I don't think it's that great at all ;). Parse times jumped from 1.1 to 1.4 sec. Try to switch off QC_USE_PRODUCT_QUERY_DETECTION (set it to FALSE) in includes/extra_configures/query_cache.php .

Can someone please remind me again of where I turn on the parse time/queries/etc on my cart so I can see what is happening? Thanks!

Admin / Configuration / Logging

You will see a setting: Display The Page Parse Time

change it to true to turn it on

marcopolo:

Admin / Configuration / Logging

You will see a setting: Display The Page Parse Time

change it to true to turn it on

Thanks, Marcopolo! The caffeine hadn't hit my fuzzy brain yet when I posted that!:laugh:

Another question. When I set QC_USE_PRODUCT_QUERY_DETECTION to FALSE the parse time goes down from 1.049 to .842 seconds but the number of queries goes up from 223 to 443. The difference in parse time is negligible from a human perspective, but I was wondering if all of the extra DB queries would slow down the rendering of the page for folks on dialup. What are your thoughts?

Thanks again, BTW, for this mod!!

data_digger:

I don't think it's that great at all ;). Parse times jumped from 1.1 to 1.4 sec. Try to switch off QC_USE_PRODUCT_QUERY_DETECTION (set it to FALSE) in includes/extra_configures/query_cache.php .

Did that....went from:

Parse Time: 1.145 - Number of Queries: 258 - Query Time: 0.0773490972748

to:

Parse Time: 1.149 - Number of Queries: 302 - Query Time: 0.0448521974335

The tried setting QC_ZEN_GET_CATEGORIES_PRODUCTS_LIST_PREFETCH to TRUE and got:

Parse Time: 1.149 - Number of Queries: 297 - Query Time: 0.0475028657989

So it actually jumped up LOL

after installation of query cache V1.6, the configuration menu in Admin were destroyed into "?????", (originally they are in Chinese)

what is problem maybe? thanks in advance:clap:

hello, Digger,

Are you there?
Any suggestin about above problem?
thanks in advance:clap:

Hey Data Digger,

Just received this error and thought I let you know just in case it's a bug and has to be addressed in the next release.

PHP Warning: Variable passed to each() is not an array or object in query_factory.php on line 184

Does anyone know how I can UNINSTALL this plugin???

Jerry5763837:

after installation of query cache V1.6, the configuration menu in Admin were destroyed into "?????", (originally they are in Chinese)

what is problem maybe? thanks in advance:clap:

Hm.. I'm not sure. Are You sure You didn't installed any other modules (for example Query Log?) Query Cache does not execute any SQL statements upon installation, does not override any language files etc.

As this applies only to Configuration menu, I get a filling that You also installed Query Log?