[wp-trac] [WordPress Trac] #38828: update_blog_details() performance improvement ideas

[WordPress Trac]

#38828: update_blog_details() performance improvement ideas
-------------------------+-------------------------------------------------
 Reporter:               |      Owner:
  boonebgorges           |     Status:  new
     Type:  defect       |  Milestone:  Future Release
  (bug)                  |    Version:
 Priority:  normal       |   Keywords:  needs-patch needs-unit-tests good-
Component:  General      |  first-bug
 Severity:  normal       |
  Focuses:  multisite,   |
  performance            |
-------------------------+-------------------------------------------------
 I've got a site running a plugin that deletes lots of posts in bulk. This
 triggers `update_blog_details()` (long story), which triggers lots of
 unnecessary `UPDATE` queries.

 The most obvious one that can be skipped is `update_option( 'blog_public'
 ... )`. There's no need to run this if the value hasn't changed.

 It's a shame that we have to clear all blog caches
 (`refresh_blog_details()` -> `clean_blog_cache()`) every time a blog's
 `last_updated` key is modified, but I don't see a way around this that
 doesn't involve lots of research.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/38828>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform