[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 lenasterg):

 Hi.
 I think also in /bp-activity/bp-activity-classes.php at line 295
 the

 {{{
 // Select conditions
         $select_sql = "SELECT DISTINCT a.id";
 }}}


 should change to
 {{{
 // Select conditions
         $select_sql = "SELECT a.id";
 }}}

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