Thread

I am operating a site that is using EE 1.6.7 currently (I plan on upgrading to latest 1.6.x build soon), and I’m experimenting with several different performance-related changes.

Some odd results occur when I activate tag caching on some weblog:entries tags. When I implement them, they reduce the total queries executed for the page as expected, but it doesn’t always reduce the elapsed time to generate the page. In fact, I have one instance where activating tag caching reduced total queries by 10 but increased time from under 2 seconds to ~5-7 seconds.

The tag I’m seeing this happen with is below:

{exp:weblog:entries weblog="stories" category="{category_id}" dynamic="off" limit="20" orderby="date" sort="desc" disable="category_fields|trackbacks" cache="yes" refresh="60" paginate="both" show_future_entries="yes"}

Can anyone explain why fewer queries, in this case, actually increased the page render time?

[Mod Edit: Moved to the Technical Support forum]

Caching can be tricky, and a lot will depend on your local server and setup. If your db server already does some caching of its own, eg, turning on caching in EE can actually have a detrimental effect as you have seen. There’s really no other way than to experiment a little.