caching of options tables on multisite network

  • I’m not entirely sure how redis works alongside the built in wordpress caching, but I do know that in general this plugin has sped up my site.

    On a multisite network, I get a lot of slow queries like,

    SELECT option_name, option_value
    FROM xxxxxx_2788_options
    WHERE autoload = ‘yes’

    on a page refresh they load quickly, but then 10 minutes later I’m getting the same slow queries.

    I have 2gb defined for redis, and I’ve never seen it use over 1gb

    Is it possible to use wp-config defines to make sure these types of queries are cached?

    P.S. Sent you a thank you via paypal

Viewing 1 replies (of 1 total)
  • Plugin Author Till Krüss

    (@tillkruess)

    Thanks for your support!

    Sadly it’s up to WP itself to cache those queries. You can theoretically write your own caching for them using filter, but that’s more of a Redis Cache Pro endeavor.

    For now, I’d suggest installing the Debug Bar plugin as well as Query Monitor. Then go to a slow loading page and see how many SQL queries are fired and how many cache hits/missing you have with the object cache.

    If you want to post screenshots or videos, that would be helpful.

Viewing 1 replies (of 1 total)
  • The topic ‘caching of options tables on multisite network’ is closed to new replies.