[buddypress-trac] [BuddyPress] #4045: Activity Feed queries fail with millions of rows

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Thu May 10 00:43:07 UTC 2012


#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 - Would you be willing to share an `EXPLAIN` of the problematic
 `get_activity_comments()` query? When I test on my environment (~1.5M rows
 in wp_bp_activity), MySQL is optimizing pretty well (indexing on
 `item_id`), but maybe it's not happening for you (in which case I will
 play with some index hints).

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


More information about the buddypress-trac mailing list