[buddypress-trac] [BuddyPress Trac] #7515: Inefficient db query

[buddypress-trac]

#7515: Inefficient db query
--------------------------+-----------------------------
 Reporter:  sourfew       |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Core          |    Version:  2.8.2
 Severity:  normal        |   Keywords:  needs-patch
--------------------------+-----------------------------
 Very slow db query for logged out users on all pages.

 Wordpress: 4.7.3
 Buddypress: 2.8.2
 bbpress: 2.6b2
 25000 users

 With QueryMonitor I can see the following
 SELECT
 wp_users.ID,wp_users.user_login,wp_users.user_pass,wp_users.user_nicename,wp_users.user_email,wp_users.user_url,wp_users.user_registered,wp_users.user_activation_key,wp_users.user_status,wp_users.display_name
 FROM wp_users
 WHERE 1=1
 AND wp_users.ID IN (40269,32606,34524,34322,40331,40334,36153,25677… and
 all 25000 user id’s

 Caller is WP_User_Query->query()
 wp-includes/class-wp-user-query.php:600

 Component:
 Plugin buddypress

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/7515>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac