WordPress.org
Get WordPress

Make WordPress Core

Opened 17 years ago

Closed 17 years ago

Last modified 6 years ago

#5179 closed defect (bug) (fixed)

Use INNER JOIN instead of LEFT JOIN for taxonomy

Reported by: ryan's profile ryan Owned by:
Milestone: 2.3.1 Priority: normal
Severity: normal Version: 2.3
Component: General Keywords: taxonomy performance
Focuses: Cc:

Description

We really don't need LEFT JOIN as far as I can tell. Let's use the faster INNER JOIN.

Attachments (1)

left_join.diff​ (5.6 KB) - added by ryan 17 years ago.

Download all attachments as: .zip

Change History (6)

@ryan
17 years ago

#1 @ryan
17 years ago

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

(In [6224]) Use inner joins instead of left joins for taxonomy. Inner is faster. fixes #5179

#2 @ryan
17 years ago

  • Milestone changed from 2.4 to 2.3.1

Nominating for 2.3.1. We might like the performance bump there.

#3 @ryan
17 years ago

(In [6253]) Use inner joins instead of left joins for taxonomy. Inner is faster. fixes #5179 for 2.3

#4 @ryan
17 years ago

Decided to go for it for 2.3. We've been using this on wordpress.com without incident and it does create a nice performance bump.

This ticket was mentioned in ​Slack in #cli by schlessera. ​View the logs.
6 years ago

Note: See TracTickets for help on using tickets.