[buddypress-trac] [BuddyPress] #4045: Activity Feed queries fail with millions of rows

[buddypress-trac at lists.automattic.com]

#4045: Activity Feed queries fail with millions of rows
-----------------------------------+--------------------
 Reporter:  zacechola              |       Owner:
     Type:  defect (bug)           |      Status:  new
 Priority:  normal                 |   Milestone:  1.6
Component:  Activity               |     Version:  1.5.4
 Severity:  normal                 |  Resolution:
 Keywords:  2nd-opinion has-patch  |
-----------------------------------+--------------------

Comment (by shanebp):

 Replying to [comment:37 shanebp]:
 > boone-
 >
 >
 > {{{
 > EXPLAIN SELECT a . * , u.user_email, u.user_nicename, u.user_login,
 u.display_name, pd.value AS user_fullname
 > FROM wp_bp_activity a, wp_users u, wp_bp_xprofile_data pd
 > WHERE u.ID = a.user_id
 > AND pd.user_id = a.user_id
 > AND pd.field_id =1
 > AND a.type =  'activity_comment'
 > AND a.item_id =577900
 > AND a.mptt_left
 > BETWEEN 1
 > AND 4
 > ORDER BY a.date_recorded ASC ;
 >
 >
 >
 >
 > id    select_type     table   type    possible_keys   key     key_len
 ref     rows    Extra
 > 1     SIMPLE  a       ref     user_id,item_id,type,mptt_left  type
 227     const   32148   Using where; Using filesort
 > 1     SIMPLE  u       eq_ref  PRIMARY PRIMARY 8       PRIME.a.user_id 1
 Using where
 > 1     SIMPLE  pd      ref     field_id,user_id        user_id 8
 PRIME.a.user_id 12      Using where
 > }}}

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