[buddypress-trac] [BuddyPress] #5210: Using DISTINCT in the select statement when retrieving activity data slows down the query

[buddypress-trac]

#5210: Using DISTINCT in the select statement when retrieving activity data slows
down the query
-------------------------------+------------------------------
 Reporter:  kwerri             |       Owner:
     Type:  enhancement        |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Activity           |     Version:  1.8.1
 Severity:  normal             |  Resolution:
 Keywords:  reporter-feedback  |
-------------------------------+------------------------------

Comment (by kwerri):

 Here's the result, boonebgorges:

 {{{
 +----+-------------+----------------+-------+----------------------------+---------------+---------+------+------+-------------+
 | id | select_type | table          | type  | possible_keys              |
 key           | key_len | ref  | rows | Extra       |
 +----+-------------+----------------+-------+----------------------------+---------------+---------+------+------+-------------+
 |  1 | SIMPLE      | wp_bp_activity | index | type,hide_sitewide,is_spam |
 date_recorded | 8       | NULL |   40 | Using where |
 +----+-------------+----------------+-------+----------------------------+---------------+---------+------+------+-------------+
 }}}

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