[buddypress-trac] [BuddyPress Trac] #7442: Use JOIN rather than Subquery on user search

[buddypress-trac]

#7442: Use JOIN rather than Subquery on user search
--------------------------+-----------------------------
 Reporter:  brandonliles  |      Owner:
     Type:  enhancement   |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Core          |    Version:
 Severity:  normal        |   Keywords:
--------------------------+-----------------------------
 The user search relies on two subqueries. This is a known weakness of
 MySQL performance. Using joins will improve performance.

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