[buddypress-trac] [BuddyPress Trac] #5128: Move user and group last_activity out of wp_usermeta

buddypress-trac noreply at wordpress.org
Wed Feb 12 21:27:21 UTC 2014

#5128: Move user and group last_activity out of wp_usermeta
 Reporter:  boonebgorges             |       Owner:
     Type:  enhancement              |      Status:  new
 Priority:  high                     |   Milestone:  2.0
Component:  Core                     |     Version:
 Severity:  major                    |  Resolution:
 Keywords:  has-patch needs-testing  |

Comment (by boonebgorges):

 In [changeset:"7860"]:
 #!CommitTicketReference repository="" revision="7860"
 Migrate user 'last_activity' data from usermeta to the activity table

 Storing last_activity in usermeta caused severe bottlenecks on sites with
 large user bases. The usermeta table has a tendency to get bloated. Its
 option_value column is not indexed, and even if it were, it would not be
 indexed properly for the kind of chronological sorting that BuddyPress was
 using it for.

 This changeset refactors all core last_activity user functionality, so
 the data is stored in the wp_bp_activity table (even when the activity
 component is disabled).

 For backward compatibility with plugins that reference last_activity
 entries, all last_activity data is retained in wp_usermeta, and new data
 be mirrored there until further notice.

 See #5128

Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5128#comment:22>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac

More information about the buddypress-trac mailing list