[buddypress-trac] [BuddyPress Trac] #7436: Very slow check_is_friend function

[buddypress-trac]

#7436: Very slow check_is_friend function
--------------------------+------------------
 Reporter:  januzi_pl     |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  high          |   Milestone:  3.0
Component:  Friends       |     Version:  2.7
 Severity:  major         |  Resolution:
 Keywords:  dev-feedback  |
--------------------------+------------------

Comment (by DJPaul):

 Testing the patch per your comments would require a differently-configured
 test environment in the matrix, if we wanted to do that. I think we should
 look at using something like `wp_is_large_network()` for this, rather than
 a new filter. As if that's enabled, presumably, other bits of WordPress
 would work more optimally on such large sites.

 Generally for SQL changes, for easier review, it's helpful to provide a
 SQL `EXPLAIN` for the query.

 Regardless of that, running an uncached SQL query on the front-end is
 never going to scale, unfortunately -- especially for something where it's
 dynamic based on the current user (and we can't just stick a static page
 cache in front of it).

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