[buddypress-trac] [BuddyPress] #3972: Database query needs optimization - BP_Core_User->get_users

[buddypress-trac at lists.automattic.com]

#3972: Database query needs optimization - BP_Core_User->get_users
----------------------------+-----------------------------
 Reporter:  arpit.tambi.in  |       Owner:
     Type:  enhancement     |      Status:  new
 Priority:  normal          |   Milestone:  Future Release
Component:  Core            |     Version:  1.5.3
 Severity:  normal          |  Resolution:
 Keywords:                  |
----------------------------+-----------------------------

Comment (by arpit.tambi.in):

 I have more to say, I found that this query is being used as basic
 member/profile search in buddypress. Urls like these -
 http://www.example.com/members/?s=Arkansas make use of this query.

 Each time the query is executed, mysqld CPU usage spikes up for sometime.

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