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

 Thanks for drawing the connection, cnorris23. See also #4060, where I make
 a two-query suggestion for the members query.

 We would need some benchmarking to see if the two-query solution would
 help in the case of activity. In my tests, it's *not* the LIMIT query that
 is causing performance problems - they run reasonably fast when using the
 correct indexes - but the COUNT query. Doing a separate get_col() query
 wouldn't help much with that. (Though I would be happy to be shown wrong.)

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