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

 FWIW, this is pretty much the exact same issue as addressed in #WP18536.
 The solution there was to use two queries. One get_col query like

 {{{
 SELECT a.id
 FROM bp_activity a
 WHERE a.type IN ( 'new_blog_post' ) AND a.hide_sitewide = 0
 AND a.type != 'activity_comment'
 ORDER BY a.date_recorded
 DESC LIMIT 0, 2
 }}}

 to get just the ids. From there we would run a second query to fill the
 objects using an added IN statement based on the ids we retrieved. They
 also through in some clever caching.

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