[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 - My patches so far do not address the kinds of queries that you
 reference here. Your example query is not limited, which means that
 somewhere in your install, BP_Activity_Activity::get() is being called
 with $per_page and/or $page being set to 0. I don't know off the top of my
 head where this happens in BP is in `bp_activity_get_specific()`, but all
 of the calls to `bp_activity_get_specific()` throughout BP also pass
 through `activity_ids`, which does not appear to be reflected in your
 example query. Do you have a way of tracing where that query is
 originating? What plugins are you running?

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