[wp-trac] [WordPress Trac] #16826: Optimize SQL for term exclusions

[WordPress Trac]

#16826: Optimize SQL for term exclusions
-------------------------+----------------------
 Reporter:  scribu       |       Owner:  scribu
     Type:  enhancement  |      Status:  closed
 Priority:  normal       |   Milestone:
Component:  Performance  |     Version:
 Severity:  normal       |  Resolution:  invalid
 Keywords:  has-patch    |
-------------------------+----------------------
Changes (by scribu):

 * status:  accepted => closed
 * resolution:   => invalid
 * milestone:  3.2 =>


Comment:

 Indeed.

 Testing again gives me 0.0955 seconds for the original query and 1.0281
 seconds for the LEFT JOIN. 2 order of magnitudes slower.

 I guess I was confused by the DEPEDANT SUBQUERY wording. It's not
 dependant at all; it' a unique subquery, which is pretty fast.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16826#comment:6>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software