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

 shanebp - Thanks for doing research. Would love to hear more.

 Keep in mind that we already have an activity transaction table:
 wp_bp_activity. I know that there are already some indexing/speed issues
 with that table (see eg #4045), but if we could solve some of them, it
 would be nice to use a table that we already have. In this case, it would
 only add as many rows to the table as there are members, as you only need
 to store the *last* activity for a given user. (I imagine this would be
 done with a new activity type - user_last_activity, group_last_activity,
 etc.) Then, instead of joining against wp_bp_activity in BP_Core_User, we
 could consider doing a subquery.

 In any case, it would be nice to do some benchmarks with, say, a million
 test users (current setup vs standalone table vs additional activity type
 in wp_bp_activity).

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