[buddypress-trac] [BuddyPress] #4609: Group count database query needs optimization

[buddypress-trac]

#4609: Group count database query needs optimization
----------------------------+-----------------------------
 Reporter:  arpit.tambi.in  |       Owner:
     Type:  enhancement     |      Status:  new
 Priority:  normal          |   Milestone:  Future Release
Component:  Groups          |     Version:
 Severity:  normal          |  Resolution:
 Keywords:                  |
----------------------------+-----------------------------

Comment (by boonebgorges):

 It's worth testing whether simply switching the join order would fix it,
 since presumably the group member part of the query will yield far fewer
 results than the groups portion. I can run some benchmarks at some point,
 but this will definitely be fixed faster if someone else can do it.

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