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

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Fri Feb 24 19:15:05 UTC 2012

#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/>

More information about the buddypress-trac mailing list