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

 I'm no expert on queries, but perhaps this would help.

 The SELECT DISTINCT u.ID... does a join on wp_usermeta looking for
 'last_activity'

 Due to the structure of wp_usermeta,  'last_activity' cannot be indexed,
 correct ?

 Then maybe 'last_activity' should be in a separate table for BP so that it
 can be indexed.

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