[buddypress-trac] [BuddyPress] #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           |   Keywords:  early
-----------------------------+-----------------------------
 On large installations with thousands/millions of users, a few of our user
 queries are looking for DISTINCT results on columns that already contain
 unique data; namely, the `id` column.

 See: `BP_User_Query::prepare_user_ids_query()`

 Related, Andy had noticed this years ago in r3023 and removed one, but it
 eventually crept back in, either in a later merge, or copy/pasted from a
 different query.

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