[wp-trac] [WordPress Trac] #12891: Advanced multi-taxonomy WP_Query()s

[WordPress Trac]

#12891: Advanced multi-taxonomy WP_Query()s
----------------------------+-----------------------------------------------
 Reporter:  markjaquith     |       Owner:  markjaquith    
     Type:  task (blessed)  |      Status:  assigned       
 Priority:  normal          |   Milestone:  3.1            
Component:  Query           |     Version:  3.0.1          
 Severity:  normal          |    Keywords:  ongoing-project
----------------------------+-----------------------------------------------

Comment(by ryan):

 Since the decision to switch away from NOT IN to a subquery for exclusions
 happened in IRC, let me fill in the background.  NOT IN was scanning the
 whole table (almost 200k rows).  The same query without the "NOT" scanned
 only 5k rows.  The unbounded subquery we switched to for exclusions is
 much faster, as mentioned above.

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