[buddypress-trac] [BuddyPress] #4060: Improve performance of BP_Core_User::get_users()

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Sat May 26 23:47:30 UTC 2012

#4060: Improve performance of BP_Core_User::get_users()
 Reporter:  shanebp                |       Owner:
     Type:  enhancement            |      Status:  new
 Priority:  normal                 |   Milestone:  Future Release
Component:  Members                |     Version:  1.2.9
 Severity:  critical               |  Resolution:
 Keywords:  1.7-early 2nd-opinion  |

Comment (by boonebgorges):

 shanebp - This is extraordinarily helpful. Thanks so much for passing it

 The first query is related to activity index hints, covered in #4045. I
 have copied that part of your comment there, along with a question for

 The second tip will probably become irrelevant when we do some of the
 planned refactoring. We'll no longer be joining wp_users against
 wp_usermeta in order to get the information; we'll be using properly
 indexed tables instead. No join + indexes means that there will be no need
 for temp tables.

 Thanks again for your persistence on this. Your help has been crucial in
 tracking down the problematic queries.

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

More information about the buddypress-trac mailing list