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

 boone -

 To clarify, we're using the public version of BP 1.5.5 - not the trunk.
 So I haven't added the 4045.03 patch.

 Manually adding the 5940 / 5953 patches helped.

 Looking at the overnight mysql log:
 I see the same thing as zacechola re "SELECT a.*, u.user_email,..." -
 "...as long as the activity is evenly spread out, we do OK with the patch,
 but as soon as we see a spike in updates, we're in trouble..."

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