[buddypress-trac] [BuddyPress Trac] #5303: DISTINCT causing poor performance on user queries

[buddypress-trac]

#5303: DISTINCT causing poor performance on user queries
-----------------------------+------------------------------
 Reporter:  johnjamesjacoby  |       Owner:  johnjamesjacoby
     Type:  defect (bug)     |      Status:  new
 Priority:  normal           |   Milestone:  2.0
Component:  Core             |     Version:  1.2
 Severity:  normal           |  Resolution:
 Keywords:  early            |
-----------------------------+------------------------------

Comment (by boonebgorges):

 Yes, we can probably drop DISTINCT in these cases. There should be blocks
 elsewhere in BP to ensure that each group-user pair can only receive one
 membership. Though, fwiw, the impact of this particular DISTINCT is
 probably very, very small, because we're only selecting the heavily
 indexed `group_id` column.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5303#comment:13>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac