Query Cache v1.0

[ttfan]

Ahhh, so it contains no database changes at all?

If that's the case, you're right... I can just backup the old files, overwrite them with the new ones, and try it on my 'live' site. If it does not work, I can just restore the old files.

[ttfan]

Can someone please confirm that Query Cache does not made any modifications to the database?

Of course I'll still backup all files and the database before I make any changes, but if no database changes are made, I can very quickly just test it on my live site, and if it does not work, simply swap back the 2 files that it changes.

Thanks a lot!

[infogate]

Can someone please confirm that Query Cache does not made any modifications to the database?

Of course I'll still backup all files and the database before I make any changes, but if no database changes are made, I can very quickly just test it on my live site, and if it does not work, simply swap back the 2 files that it changes.

Thanks a lot!

Hello once again.
I have already confirmed that.
You really have nothing to be afraid of.
You can even confirm that inside the readme file of the creator.
It just replaces a few files that you can just back up.

Hope this was helpfull

[ttfan]

THanks again for you help!

It seems to work well... a lot less queries, although I'm not quite sure if the Parse time has improved much... perhaps when the server is busy the improvement will be much more obvious.

[solo_400]

Hello Everyone ,

Is this module still useful and compatible with v.1.5.0 also ?

Thank you very much !

[DrByte]

It's built-in to v1.5.1

[Eric Chen]

Hello, Everyone,

I installed the plugin in my website. It seems quite good and reduce many sql query.
without Query Cache: 2000+ queries
with Query Cache v1.6: about 500 queries

But it seems having a bug. My website in browser will show following wrong code when I upload a product to my store.

1062 Duplicate entry 'ca34fbe5f9a075091ad59abf02c259a7-1' for key 1
in:
[INSERT INTO seo_cache (cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires) VALUES ('ca34fbe5f9a075091ad59abf02c259a7', '1', 'seo_urls_v2_products', /GbVE6QO7VPWmV2X+v2B7jb8RuacilmdVghNzVjNS1US7i1Pn/PhT/K4j2YLH6jlv7iYbBhjD6abt5uZMCymyYs0Bzt/wc=', '1', '1', 'EVAL', '2013-03-26 03:27:49', '2013-04-25 03:27:49')]

The above wrong code only shows one time on browser, after I upload a new product into my store. And then my website is OK if I repeat to click any page. Please anyone has ever met the same issue, or any advise regarding above wrong code. Thank you in advance.

[infogate]

Hello, Everyone,

I installed the plugin in my website. It seems quite good and reduce many sql query.
without Query Cache: 2000+ queries
with Query Cache v1.6: about 500 queries

But it seems having a bug. My website in browser will show following wrong code when I upload a product to my store.

1062 Duplicate entry 'ca34fbe5f9a075091ad59abf02c259a7-1' for key 1
in:
[INSERT INTO seo_cache (cache_id, cache_language_id, cache_name, cache_data, cache_global, cache_gzip, cache_method, cache_date, cache_expires) VALUES ('ca34fbe5f9a075091ad59abf02c259a7', '1', 'seo_urls_v2_products', /GbVE6QO7VPWmV2X+v2B7jb8RuacilmdVghNzVjNS1US7i1Pn/PhT/K4j2YLH6jlv7iYbBhjD6abt5uZMCymyYs0Bzt/wc=', '1', '1', 'EVAL', '2013-03-26 03:27:49', '2013-04-25 03:27:49')]

The above wrong code only shows one time on browser, after I upload a new product into my store. And then my website is OK if I repeat to click any page. Please anyone has ever met the same issue, or any advise regarding above wrong code. Thank you in advance.

Witch is the Zen Cart version you are using query cache?

[Eric Chen]

Witch is the Zen Cart version you are using query cache?

The Zen Cart version is 1.3.8a. Thank you.

[infogate]

The Zen Cart version is 1.3.8a. Thank you.

I suggest unistall V1.7 cause it is tested and works fro 1.3.9 installations and try an older version like 1.6 or 1.6.1.

The other option is to update zencart installation :)

If you're not upgrading for awhile, a good idea is to try one of the following tips ---> http://www.data-diggers.com/advanced...formance-tips/

Remember before any change!!! Backup to be able to go back!