W3 Total Cache plugin: Crazy huge cached DB queries..

  • I turned on debug mode to check if my DB was being cached. It appeared it was, but after a while I started to see crazy huge queries. such as:

    SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN (‘category’, ‘post_tag’) AND tr.object_id IN (9488, 9479, 9472, 9465, 9453, 9430, 9426, 9418, 9412, 9406, 9402, 9372, 9385, 9376, 9367, 9360, 9347, 9322, 9298, 9309, 9307, 9305, 9303, 9301, 9295, 9289, 9278, 9275, 9268, 9264, 9252, 9221, 9214, 9205, 9199, 9175, 9186, 917………) ORDER BY t.name ASC

    Literally like 3-4 Full pages long. Is this some bad interaction with a plugin? It doesn’t look like my cache will last long if the queries get this big. Also there are similar large queries for wp_postmeta AND wp_posts TAbles.. If you want i can keep the debug info on my site, but at this rate ill probbly have to stop cacheing, since it appears to be growing.

    I have random posts showing in the sidebar.. as well as

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter ericbojo

    (@ericbojo)

    Hm Strange thing. I only notice this when I am logged in. I guess there is alot more going on a logged in page.

    Thread Starter ericbojo

    (@ericbojo)

    Had to turn off DB caching because it slowed my site to a crawl.. took about 1 hour to do so.

    I get long queries like that too, but how do you know they are related to W3TC?
    I haven’t seen any slow-down problems.

    Literally like 3-4 Full pages long. Is this some bad interaction with a plugin? It doesn’t look like my cache will last long if the queries get this big. Also there are similar large queries for wp_postmeta AND wp_posts TAbles.. If you want i can keep the debug info on my site, but at this rate ill probbly have to stop cacheing, since it appears to be growing.

    When logged in, no caching is done unless you’ve changed the default settings.

    The plugin doesn’t “cause” problems, it will just show you what your site already does and try to speed things up. For any type of caching there is some exception that breaks it. Size of responses, speed of the disk and many other things can cause something to “break”. If you use APC for example you will likely get a better result. Optionally you can also disable keep those queries from being cached, although it would be better for your site if they could be. Since you have not specified your caching method I can only speculate.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘W3 Total Cache plugin: Crazy huge cached DB queries..’ is closed to new replies.