[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:  Awaiting Review
Component:  Activity      |    Version:  1.5.4
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 We have an activity feed that contains millions of entries that are stored
 with the newest entry at the end of the table.

 When BP tries to load the activity feed it selects the entire activity
 table and then reverse sorts it.

 This requires that the table be written out to disk.

 On a site as busy are ours, this results in a large number of queries all
 doing the same thing which brings MySQL down.

 We've tested out selecting smaller sized date ranges and then reverse
 sorting those, which has helped, but, it's not necessarily ideal.

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