[buddypress-trac] [BuddyPress Trac] #5950: Editing Pages / Posts in wp-admin creates 50, 000 SQL Queries

[buddypress-trac]

#5950: Editing Pages / Posts in wp-admin creates 50,000 SQL Queries
------------------------------------+------------------
 Reporter:  wcvendors               |       Owner:
     Type:  defect (bug)            |      Status:  new
 Priority:  high                    |   Milestone:  2.2
Component:  Activity                |     Version:  2.1
 Severity:  critical                |  Resolution:
 Keywords:  dev-feedback has-patch  |
------------------------------------+------------------

Comment (by DJPaul):

 Few thoughts:

 I think we need something like `wp_is_large_network` that checks if a user
 has "many" friends, and if so, we return out of
 `bp_friends_prime_mentions_results`. It's intended to only pre-cache
 friend lookups for quick results, but not to generate a large query, or if
 Friends are being used in a non-default way.

 We can use `$user->display_name` instead of
 `bp_core_get_user_displayname(...)` if the xprofile sync is enabled (`!
 bp_disable_profile_sync() )`. This seems like a great improvement.

 I am hesitant to use `$user->user_nicename` because I am pretty sure it
 isn't always the same as xprofile's name field. If you wanted to do this,
 I think we will need to create a whole lot of user accounts with different
 types of user name etc, and check which variant of those formats appear in
 the @mention picker UI, with and without username compatibility mode being
 enabled, to check that everything remains sane and logical. It's kind of a
 pain to do. :)

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