[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:                  |
----------------------------+-----------------------------
Changes (by DJPaul):

 * cc: boonebgorges (added)
 * milestone:  Awaiting Review => Future Release


Comment:

 I get slightly different EXPLAIN results for that query, but I'm only
 testing on a small database at the moment. This probably won't get
 addressed in BP 1.7 unless someone contributes a patch and some
 benchmarks, but am copying in Boone as he's done some SQL work for other
 parts of 1.7, and might be able to spot any easy wins

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