[wp-trac] [WordPress Trac] #31746: get_blogs_of_user() can be very slow when a user is a member of thousands of sites

[WordPress Trac]

#31746: get_blogs_of_user() can be very slow when a user is a member of thousands
of sites
--------------------------+-----------------------------
 Reporter:  jtsternberg   |       Owner:  johnbillion
     Type:  defect (bug)  |      Status:  reviewing
 Priority:  normal        |   Milestone:  Future Release
Component:  Users         |     Version:  3.0
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:  multisite
--------------------------+-----------------------------

Comment (by nerrad):

 I think the patch proposed here is a good interim measure, it at least
 allows for hooking in to modify the number of blogs returned and some
 temporary caching of results.

 However long term, I think it'd be better to introduce paging to this.  I
 realize there would be a number of implications to any ui that uses this
 function but that's something that needs improved anyways (for user's that
 legitimately _belong_ to a large number of blogs anyways).

 The good thing about this patch though, is it helps makes it possible for
 a feature plugin to be built that tests out using paging and what that
 affects.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/31746#comment:14>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform