[buddypress-trac] [BuddyPress] #4060: Improve performance of BP_Core_User::get_users()

[buddypress-trac at lists.automattic.com]

#4060: Improve performance of BP_Core_User::get_users()
-----------------------------------+-----------------------------
 Reporter:  shanebp                |       Owner:
     Type:  enhancement            |      Status:  new
 Priority:  normal                 |   Milestone:  Future Release
Component:  Members                |     Version:  1.2.9
 Severity:  critical               |  Resolution:
 Keywords:  1.7-early 2nd-opinion  |
-----------------------------------+-----------------------------

Comment (by boonebgorges):

 shanebp - This is extraordinarily helpful. Thanks so much for passing it
 along.

 The first query is related to activity index hints, covered in #4045. I
 have copied that part of your comment there, along with a question for
 you.

 The second tip will probably become irrelevant when we do some of the
 planned refactoring. We'll no longer be joining wp_users against
 wp_usermeta in order to get the information; we'll be using properly
 indexed tables instead. No join + indexes means that there will be no need
 for temp tables.

 Thanks again for your persistence on this. Your help has been crucial in
 tracking down the problematic queries.

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/4060#comment:18>
BuddyPress <http://buddypress.org/>
BuddyPress