Query Cache v1.0

Tick:

Hopefully Zen 2.0 will address the issue by moving to an object-oriented approach to products that will store the values in memory rather than needlessly re-executing queries.
As has been stated elsewhere, it does.

Thank you for this great mod!
I have a question......my web host has switched mySQL query cache on.
Will this mod cause any conflict?

Hi there,

I have this mod installed in my store and am wondering if anyone has some information on its compatibility with 1.3.9c before I attempt an upgrade.

Any help much appreciated.

I clicked through to see if there was a solution for the incompatibility between Google Base and this mod but didn't see any details. Has anyone been able to work through this?

thanks,
Don

fergusmacdonald:

Hi there,

I have this mod installed in my store and am wondering if anyone has some information on its compatibility with 1.3.9c before I attempt an upgrade.

Any help much appreciated.

i don't think this would be compatible with 139a,b,c,d , as query_factory.php has been changed in new releases .

tony_sar:

i don't think this would be compatible with 139a,b,c,d , as query_factory.php has been changed in new releases .

You're right ... there were changes to both query_factory.php and functions_categories between zc1.3.8a and 1.3.9c. The attached zip-file has the merged version that combines Query Cache v1.6 and the respective files from ZC 1.3.9c; there is no directory structure in the zip-file, so you need to copy the files to:

/includes/classes/db/mysql/query_factory.php
/includes/functions/functions_categories.php

Anybody get this working in 1.3.9d? I tried it, and it doesn't break the cart, but it also does not lower queries.

It is a fresh install that I used my custom template from 1.3.8a.
Mod wise it has IH2.
It has php 5.2.11 and mysq 5.0.90

Tried running it with query log as well. This is the output:

QUERY DEBUG: Requested execution of: 0 queries. Executed: 7073 queries. Returned from cache: -7073 queries.

SUM: 0

Thanks!

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

lat9:

You're right ... there were changes to both query_factory.php and functions_categories between zc1.3.8a and 1.3.9c. The attached zip-file has the merged version that combines Query Cache v1.6 and the respective files from ZC 1.3.9c; there is no directory structure in the zip-file, so you need to copy the files to:

/includes/classes/db/mysql/query_factory.php
/includes/functions/functions_categories.php

Hi all

I am getting bucket loads (around one per query) of the following error messages with the above updates.

[07-Jul-2010 08:36:33] PHP Warning: mysql_data_seek() [<a href='function.mysql-data-seek'>function.mysql-data-seek</a>]: Offset 0 is invalid for MySQL result index 395 (or the query data is unbuffered) in ...\includes\classes\query_cache.php on line 38

After having tried so many combinations of the switches, I have run out of ideas how to fix.

I really appreciate your good work on QueryCache, I have read your code and want to apply in my website, but there is one thing I need to know before:
In your code,you check the existing of Cache objects, if exists, return directly, if not exists, query from database and then return. but when cache create and things changed, how can I init all the things so that it can read all the things from database again? just like SEO cache.

Zencart 1.3.9f

If I install this unto my site, does it matter what the setting is for the SQL_CACHE_METHOD? (none, file, or db)

The download file does not include Zen-cart version 1.3.9. Has anyone has success with following 1.3.8 instead?

Thanks, Kim

dw08gm:

Hi all

I am getting bucket loads (around one per query) of the following error messages with the above updates.

After having tried so many combinations of the switches, I have run out of ideas how to fix.

I'm seeing the same thing on my site. Did anyone ever solve this problem? I'm running 1.3.9f.

I got no replies so I decided to abandon the mod under 139.

Under 138, I had found only a modest improvement in performance, so abandoning the mod in 139 was no real loss as far as my site is concerned.

Since abandoning, I have found other ways to improve performance, although I have only a vague memory of what was done.

Cheers

QueryCache v1.7 for Zn Cart 1.3.9h has been released. Currently the mod is in 'beta' stage, but it should be stable.
Download QueryCache v1.7-beta-zc-1.3.9h
Please report any bugs here or on www.data-diggers.com

imustbeme:

I'm seeing the same thing on my site. Did anyone ever solve this problem? I'm running 1.3.9f.

Install the version for 1.3.9h

smoke133:

Zencart 1.3.9f

If I install this unto my site, does it matter what the setting is for the SQL_CACHE_METHOD? (none, file, or db)

It doesn't matter.

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

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

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/

:-(

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/

:-(

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.