Query Cache v1.0

[Dan123]

Hi all, first of all thanks for this great module!!!
I have a question, I found that I have 2 queries that are pretty slow. the first one is caused by my SSU module, when I checked ssu_cache table, it has more than 100,000 rows. And the second one is whoisonline. Did anybody else have this issue and knows how to fix it????
Thank you!!!!!

[data_digger]

Hi all, first of all thanks for this great module!!!
I have a question, I found that I have 2 queries that are pretty slow. the first one is caused by my SSU module, when I checked ssu_cache table, it has more than 100,000 rows. And the second one is whoisonline. Did anybody else have this issue and knows how to fix it????
Thank you!!!!!

I highly recommend changing storage engine of whos_online table to InnoDB. You'll avoid locking issues with this table (it's updated on EVERY request).

[Cindy2010]

I tried that, it reduced the number of queries, but looks like the parse time is still high, especiall on the first hit (where there is no hit to my site in the previous 15 mins or so), it can be as high as 10+ seconds:

http://www.kingoflaptops.com/

:-(

[data_digger]

I tried that, it reduced the number of queries, but looks like the parse time is still high, especiall on the first hit (where there is no hit to my site in the previous 15 mins or so), it can be as high as 10+ seconds:

http://www.kingoflaptops.com/

:-(

Can You check if query time is also high? What times do You get? PM me as it's most probably not related to QueryCache and We shouldn't continue the discussion here.

[RoboPhung]

OMG Thank you for this!!!

I was getting hit with fastcgi timeouts during the checkout process because my sql queries were taking too long when customers had a lot of items in the cart, and sure enough when I turned on page parse time logging, I was showing in excess of 30,000 queries during checkout.

I was struggling with a solution and almost had to consider a vps to possibly help with the parse times.

Your addon reduced it to less than 3,000!!! It performs even better than your claim of 80% reduction! Now I don't even need to consider moving servers. I can't thank you enough for this addon!

Oh and btw I'm using your beta version, and I'm on zencart v1.3.9h