WordPress.org

Make WordPress Core

Opened 2 years ago

Closed 2 years ago

#19999 closed defect (bug) (fixed)

Don't allow user_url searches on large networks

Reported by: ryan Owned by: ryan
Milestone: 3.4 Priority: normal
Severity: normal Version: 3.3.1
Component: Users Keywords:
Focuses: 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 (1)

19999.diff (585 bytes) - added by ryan 2 years ago.

Download all attachments as: .zip

Change History (4)

ryan2 years ago

comment:1 ryan2 years ago

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

comment:2 nacin2 years ago

Looks good.

comment:3 ryan2 years ago

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

In [19886]:

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

Note: See TracTickets for help on using tickets.