[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:  2.9
Component:  Core                    |     Version:
 Severity:  normal                  |  Resolution:
 Keywords:  has-patch dev-feedback  |
------------------------------------+------------------

Comment (by brandonliles):

 After seeing the query still perform poorly on a site I took another look,
 although joins can improve performance, MySQL still tends to look at too
 many rows in the bp_activity table. Determining the matching user_ids
 first and plugging those values into the query is a major performance
 improvement.

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