[Plugin: W3 Total Cache] Does W3TC unpack slow queries (on purpose)

  • Greg

    (@rebootnow)


    13 years, 8 months ago

    I watch the number of queries my site generates like a hawk, so I immediately noticed that when I enabled W3TC the number of queries on certain pages went UP. I used SAVEQUERIES to dig into that and found that 1 original query had been expanded to 20+ queries by W3TC.

    Now, the 1 query was a slow query (to find the top 20 most commented posts), so perhaps the expanded version is better. It does seem to eliminate a completely gratuitous inner join, but then also issues 20 individual queries to get the posts which would be far better done with a single query.

    I would like to know whether this is expected behavior. That is, is W3TC breaking down slow queries in order to improve performance? Am I seeing a feature or just a side effect?

Viewing 1 replies (of 1 total)
  • Thread Starter Greg

    (@rebootnow)

    13 years, 8 months ago

    Just to add: I recently saw a case where W3TC took a page from 30 queries to 99 queries. I plan to dig into this at some point, but don’t have time for it now. I suspect that W3TC is undoing some of the explicit caching that I am doing using wp_cache_set.

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: W3 Total Cache] Does W3TC unpack slow queries (on purpose)’ is closed to new replies.