[buddypress-trac] [BuddyPress] #4060: slow queries in bp-core-classes

[buddypress-trac at lists.automattic.com]

#4060: slow queries in bp-core-classes
--------------------------+--------------------
 Reporter:  shanebp       |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  1.6
Component:  Members       |     Version:  1.2.9
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+--------------------

Comment (by shanebp):

 The more I look at this, the more I'm convinced that BP will _never_ scale
 while member last_activity is stored in wp_usermeta.

 Moving last_activity into wp_users makes the most sense but would go
 against WP and make updating a mess.

 So I'm going to try changing update_user_meta to write to a separate table
 and point Select statements to that table. Still a bunch of work.

 Groups->last_activity is not an issue even though we have ~600 groups.

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