[buddypress-trac] [BuddyPress Trac] #7487: Friends: Drop the number of friends used for priming at-mention suggestions

[buddypress-trac]

#7487: Friends: Drop the number of friends used for priming at-mention suggestions
--------------------------+-----------------------------
 Reporter:  r-a-y         |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Friends       |    Version:  2.2
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 We have set 150 friends as the limit for use with the at-mentions
 suggestions prime script (see #5950):
 https://buddypress.trac.wordpress.org/browser/tags/2.8.2/src/bp-friends
 /bp-friends-functions.php?marks=785-787#L766

 We should probably drop that number even more because the user DB query
 used to fetch the user data can still be quite large.

 eg. `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 ( add 150 user IDs here )`

 See the following support thread for an example:
 https://buddypress.org/support/topic/need-help-troubleshooting-this-error-
 in-buddypressbp-coreclassesclass-bp-user/

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