[wp-trac] [WordPress Trac] #10576: Use subqueries for taxonomy queries

WordPress Trac wp-trac at lists.automattic.com
Mon Aug 10 22:52:39 UTC 2009


#10576: Use subqueries for taxonomy queries
----------------------------+-----------------------------------------------
 Reporter:  ryan            |       Owner:  filosofo
     Type:  task (blessed)  |      Status:  new     
 Priority:  normal          |   Milestone:  2.9     
Component:  Taxonomy        |     Version:          
 Severity:  normal          |    Keywords:          
----------------------------+-----------------------------------------------

Comment(by Denis-de-Bernardy):

 err, nm on the merge join mention in the first query, it's definitely
 looking forward for a hash join. but anyway... :-P

 using the joins instead of subqueries will be faster if there is no IN()
 clause, and an order by limit.

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


More information about the wp-trac mailing list