Ticket #19999 (closed defect (bug): fixed)

Opened 4 months ago

Last modified 4 months ago

Don't allow user_url searches on large networks

Reported by: ryan Owned by: ryan
Priority: normal Milestone: 3.4
Component: Users Version: 3.3.1
Severity: normal Keywords:
Cc:

Description

WP_User_Query queries against user_url when the search term looks like a URL. Since user_url has no index, this is very slow on networks with lots of users. Given that user_url searching isn't that useful anyway, let's disable useR_url searches on large networks.

Attachments

19999.diff Download (585 bytes) - added by ryan 4 months ago.

Change History

ryan — 4 months ago

comment:1   ryan — 4 months ago

Patch excludes user_url from the default search columns. Plugins can still request user_url searches via the search_columns arg.

comment:2   nacin — 4 months ago

Looks good.

comment:3   ryan — 4 months ago

  • Owner set to ryan
  • Status changed from new to closed
  • Resolution set to fixed

In [19886]:

Exclude user_url from default user search columns for large networks. fixes #19999

Note: See TracTickets for help on using tickets.