[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:  reporter-feedback  |
-------------------------------+--------------------

Comment (by zacechola):

 No. I mean activity. Either on the activity page itself or on the user
 profiles.

 As the site grows, the current solution doesn't seem to scale very well
 because it tries to pull the entire table, reverse sort it, and then apply
 any filters. When this table is huge, there needs to be some checks in
 place to limit the size of the query.

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