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

[WordPress Trac]

#16826: Optimize SQL for term exclusions
-------------------------+-----------------------------
 Reporter:  scribu       |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Taxonomy     |    Version:
 Severity:  normal       |   Keywords:  has-patch
-------------------------+-----------------------------
 When calling WP_Query with an argument like 'cat=-1', the
 WP_Tax_Query::get_sql() method uses a dependant subquery to retrieve posts
 that don't belong to that category.

 This can be achieved in a more efficient way by using a LEFT JOIN.

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