Ticket #5179 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

Use INNER JOIN instead of LEFT JOIN for taxonomy

Reported by: ryan Assigned to: anonymous
Priority: normal Milestone: 2.3.1
Component: General Version: 2.3
Severity: normal Keywords: taxonomy performance
Cc:

Description

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

Attachments

left_join.diff (5.6 kB) - added by ryan on 10/11/07 02:12:29.

Change History

10/11/07 02:12:29 changed by ryan

  • attachment left_join.diff added.

10/11/07 17:43:49 changed by ryan

  • status changed from new to closed.
  • resolution set to fixed.

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

10/11/07 17:44:28 changed by ryan

  • milestone changed from 2.4 to 2.3.1.

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

10/15/07 20:14:56 changed by ryan

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

10/15/07 20:15:30 changed by ryan

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.