[wp-trac] [WordPress Trac] #42280: Multisite: get_blogs_of_user has no useful caching on large installs

[WordPress Trac]

#42280: Multisite: get_blogs_of_user has no useful caching on large installs
------------------------------------+-----------------------------
 Reporter:  westi                   |      Owner:
     Type:  defect (bug)            |     Status:  new
 Priority:  high                    |  Milestone:  Awaiting Review
Component:  Networks and Sites      |    Version:  4.7
 Severity:  major                   |   Keywords:
  Focuses:  multisite, performance  |
------------------------------------+-----------------------------
 While thinking about the changes that were happening in #40228 we started
 to investigate other places where functions had been switched to use
 `get_sites`.

 Looking back through "recent" changes I found: [38682] / #37061.

 Previously we would fetch all the user meta for a user and then use
 get_blog_details (and it’s inherent caching) to populate the list of
 blogs.

 Now we fetch all the user meta for a user and then create a query for
 get_sites which as previously discussed has pointless caching on active
 multisites inside WP_Site_Query.

 I'm opening this ticket to ensure that the caching is also reviewed here
 too.

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