[buddypress-trac] [BuddyPress] #5303: DISTINCT causing poor performance on user queries
buddypress-trac
noreply at wordpress.org
Tue Dec 17 21:19:21 UTC 2013
#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
More information about the buddypress-trac
mailing list