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

[dw08gm]

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.

[qrhuang728]

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.

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

[kburner]

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

Thanks, Kim

[imustbeme]

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.

[dw08gm]

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

[data_digger]

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

[data_digger]

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

[data_digger]

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.