[buddypress-trac] [BuddyPress] #4251: Slow queries on Activity Stream during peak times on site.

[buddypress-trac at lists.automattic.com]

#4251: Slow queries on Activity Stream during peak times on site.
---------------------------+------------------------
 Reporter:  TheBeardedOne  |       Owner:
     Type:  defect (bug)   |      Status:  closed
 Priority:  normal         |   Milestone:
Component:  Core           |     Version:  1.5.5
 Severity:  blocker        |  Resolution:  duplicate
 Keywords:                 |
---------------------------+------------------------
Changes (by boonebgorges):

 * status:  new => closed
 * resolution:   => duplicate
 * milestone:  Awaiting Review =>


Comment:

 Thanks for the log. We've made significant improvements in BP 1.6. See the
 extended discussion in https://buddypress.trac.wordpress.org/ticket/4045 I
 encourage you to CC yourself on that ticket and chip in with any
 additional insights you may have gleaned from your experience.

 In the meantime, you're likely to see performance gains by using some sort
 of persistent object cache, as well as by fine-tuning your MySQL cache.

 > Due to Buddypress not being compatible with HyperDB, I am unable to
 mitigate this problem by throwing more DB servers at it.

 BuddyPress is definitely compatible with SharDB (and by extension, I
 believe, with HyperDB), but you're correct that the DB tables themselves
 cannot be sharded.

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