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

 shanebp - Would you be willing to share an `EXPLAIN` of the problematic
 `get_activity_comments()` query? When I test on my environment (~1.5M rows
 in wp_bp_activity), MySQL is optimizing pretty well (indexing on
 `item_id`), but maybe it's not happening for you (in which case I will
 play with some index hints).

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