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

 Good call. That is definitely the problem. (Note that `item_id` means
 something different from `activity_id`.)

 The kind of query performed in
 `BP_Activity_Activity::get_activity_comments()` is problematic in the same
 way that COUNT queries are problematic: they very often require table
 scans. I will do some testing to see whether the index hinting strategy
 implemented in the main `get()` method will help here.

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