How to cache a particular query result?

  • Resolved ajtatum

    (@ajtatum)


    3 years, 3 months ago

    I’m not sure what’s causing it, but when I look at the logs for my database hosted on DigitalOcean, there’s a query that’s being hit A TON. It looks like it’s a request to build the navigation:

    SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (84,522,1175,1176,1177,1178,1179,1180,1219,1220,1477,1478,1479,1480,1539,1586,1672,1678) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.menu_order ASC

    Is there a way I can configure Redis to cache this request so that it’s not constantly hitting the database?

    Thanks,
    AJ

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

    (@tillkruess)

    Hi AJ,

    no object caching in WordPress does not intersect with query caching. I’d use MariaDB’s Query Cache if that query is causing your trouble.

Viewing 1 replies (of 1 total)
  • The topic ‘How to cache a particular query result?’ is closed to new replies.