DB Cache Sitemap

  • karlpietsch

    (@karlpietsch)


    9 years, 6 months ago

    I noticed that my APC cache is filling up with some very large database cache objects, I have a pretty standard configuration with Yoast SEO sitemaps as recommended. The issue is that the Page Cache primer requests all the sitemaps and W3 Total Cache is caching the database queries and the sitemaps as objects. Yoast SEO queries the entire post content for every post in the site which is very large.

    The easiest solution I can come up with is to add a query regular expression in “Reject Query Words”?

    /bSELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_modified_gmt, post_date, post_date_gmt/b

    Any better suggestion?

    K

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter karlpietsch

    (@karlpietsch)

    9 years, 6 months ago

    edit
    \bSELECT l.ID, post_title, post_content, post_name, post_parent, post_author, post_modified_gmt, post_date, post_date_gmt\b

    Scott Hartley

    (@destac)

    9 years, 6 months ago

    You could try excluding the sitemap under the “Never cache the following pages: ” in the database cache settings?

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘DB Cache Sitemap’ is closed to new replies.