Query Cache v1.0

[data_digger]

I've sent PM to You.

[4thwave]

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!!!!!!!
(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

[4thwave]

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

[Website Rob]

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

[4thwave]

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

[DrByte]

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

[LissaE]

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/

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]

[LissaE]

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

[LissaE]

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

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