[wp-trac] [WordPress Trac] #27304: Improve user searching

[WordPress Trac]

#27304: Improve user searching
-------------------------------------------------+-------------------------
 Reporter:  johnbillion                          |       Owner:
     Type:  defect (bug)                         |  johnbillion
 Priority:  normal                               |      Status:  closed
Component:  Users                                |   Milestone:  4.3
 Severity:  normal                               |     Version:
 Keywords:  needs-testing has-patch dev-         |  Resolution:  fixed
  feedback                                       |     Focuses:
                                                 |  administration
-------------------------------------------------+-------------------------

Comment (by tellyworth):

 This causes problems on network installs with very large wp_users tables,
 because only user_login and user_nicename are indexed, so it does a full
 table scan.

 It can be avoided by filtering `user_search_columns` in a plugin, but it'd
 be preferable to not be broken out of the box for big installs. One
 possibility would be to only use indexed columns on multisite. There are
 probably better options, since obviously multisite is not synonymous with
 large.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/27304#comment:21>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform