[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:  DJPaul
     Type:  enhancement                   |      Status:  closed
 Priority:  normal                        |   Milestone:  3.0
Component:  Core                          |     Version:
 Severity:  normal                        |  Resolution:  fixed
 Keywords:  has-patch dev-feedback early  |
------------------------------------------+---------------------
Changes (by djpaul):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"11886"]:
 {{{
 #!CommitTicketReference repository="" revision="11886"
 Members, search: split user matching into seperate query.

 Removing the subquery decreases the amount of rows MySQL needs to look at
 in the `bp_activity` table.
 In the future, if we or WordPress add a user cache incrementor, we could
 cache this query.

 Fixes #7442

 Props brandonliles, r-a-y, boonebgorges
 }}}

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