[buddypress-trac] [BuddyPress] #3972: Database query needs optimization - BP_Core_User->get_users

[buddypress-trac at lists.automattic.com]

#3972: Database query needs optimization - BP_Core_User->get_users
----------------------------+-----------------------------
 Reporter:  arpit.tambi.in  |       Owner:
     Type:  enhancement     |      Status:  new
 Priority:  normal          |   Milestone:  Future Release
Component:  Core            |     Version:  1.5.3
 Severity:  normal          |  Resolution:
 Keywords:                  |
----------------------------+-----------------------------
Changes (by boonebgorges):

 * milestone:  Awaiting Review => Future Release


Comment:

 At least part of the slowness is coming from your join against xprofile
 for the '%%United States%%' value. You must be doing that with a plugin -
 BP does not do that out of the box.

 That said, when we do counts, we should not be joining against usermeta
 for last activity - that information is not useful for purposes of a
 count. On the other hand, if we only mean to count users who have this
 meta value (can't remember if that's intended), we could just count
 DISTINCT(um.user_id), without the join against wp_users. It would probably
 break plugins like the one you're using if we made this latter change (as
 there would be no u.ID for your ON clause), so we can't do it for this
 release - needs some more architecting.

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