Zen Simple Cache

[kelvyn]

That number of queries is not normal for a site. One of the add-ons you have installed or a modification you have made is generating a lot of SQL queries. Most likely it is either the fly-out categories side-box you are using or the tag-cloud. Try switching back to the standard categories box and see if that helps. You could also try switching off the tag-cloud.
Regards,
Christian.

I was about to put fly-out categories side-box back 3 years after it brought our site to its knees, but it doesn't sound like a good idea now! For a not-often-updated site, is there a way of caching the flyout category code?

[data_digger]

update , mod reinstalled , working but it only dropped the total queries buy 1!!! oh well bring on 1.4 :)

As far as I know the module does not reduce parse times and query times on its own. You have to decide which parts of Your store are to be cached and do it manually (again, as far as I know).

As for query count, do You have Query Cache installed?

[ryosuke]

What which file should you describe to make them cache the retrieval result?

The cash of the details of the commodity page succeeded.
Please advise.

[ryosuke]

What which file should you describe to make them cache the result of the retrieval from the search box?

The cash of the product page succeeded.
tips Please.

[kelvyn]

Looks like a great module, but it needs some instructions.

I'm going to try and figure out a bit more about how it works.
I've got one part of a page to cache, reducing my query count like this:

Zen new install with example products, before simple-cache:
First load:
Parse Time: 5.525 - Number of Queries: 278 - Query Time: 1.843069078125

Reload:
Parse Time: 1.242 - Number of Queries: 299 - Query Time: 0.29237893838501

After simple-cache, first or reload:
Parse Time: 0.113 - Number of Queries: 67 - Query Time: 0.021814021362305

Clearly a useful mod, but for anyone about to install this, before you spend an evening struggling like I did, the most recent module manager does NOT work with it.

You need this version: http://code.google.com/p/zencart-mod...p.zip&can=2&q=

I'm going to try and figure out a bit more about it, write a few instructions and examples, and hopefully upload tomorrow.

[kelvyn]

Still lost with this - where would I put the cache to make sure that JUST the categories menu (the thing that kills the site) is cached?

As I understood it, if you cache one block, you should have one file, but after 24 hours I end up with literally thousands of files.

[kelvyn]

Still lost with this - where would I put the cache to make sure that JUST the categories menu (the thing that kills the site) is cached?

As I understood it, if you cache one block, you should have one file, but after 24 hours I end up with literally thousands of files, all named things like, cache_blocks_425a5cbacf49bffc76bdefb63075f2fa all containing completely identical code.

So, for example, in tpl_main_page.php I have

<?php if(!SimpleCache::startBlock('leftcolsideboxes', true, false)): ?>
<div id="navColumnOneWrapper" style="width: <?php echo BOX_WIDTH_LEFT; ?>"><?php require(DIR_WS_MODULES . zen_get_module_directory('column_left.php')); ?></div></td><?php SimpleCache::End(); endif ?>

This saves me a few queries, and sure enough, I end up with files in the cache directory containing what should be in the sidebox.
But there are thousands of them, all the same, but with different names. Why isn't there just one?

[kelvyn]

OK, solved the "thousands of identical files" issue:

Change

<?php if(!SimpleCache::startBlock('leftcolsideboxes', true, false)): ?>

to

<?php if(!SimpleCache::startBlock('leftcolsideboxes', false, false)): ?>

Slowly slowly getting there, getting those queries down to sensible levels! With this and query_cache, I'm now down to 30 for the main page. 500 less than "stock install" and my server is now keeping alive quite well. Still 25 too many, but documenting all the time so will post here when done!

[elho]

Great mod! But I have been looking for any way to avoid "re-caching" pages with certain tracking url parameters (like utm-parameters). So that a certain page, that is not dependent on the specific tracking parameter, is fecthed from the cache rather re-cached.

Is there any way of doing this?

Best regards,
Ed