[wp-trac] [WordPress Trac] #14699: Optimize SQL resulting from custom taxonomy queries

WordPress Trac wp-trac at lists.automattic.com
Thu Aug 26 15:39:13 UTC 2010


#14699: Optimize SQL resulting from custom taxonomy queries
--------------------------+-------------------------------------------------
 Reporter:  misterbisson  |       Owner:                         
     Type:  enhancement   |      Status:  new                    
 Priority:  normal        |   Milestone:  Awaiting Review        
Component:  Query         |     Version:  3.0.1                  
 Severity:  normal        |    Keywords:  has-patch needs-testing
--------------------------+-------------------------------------------------

Comment(by misterbisson):

 A note on performance: this could be made faster yet if the terms were
 resolved to `term_taxonomy_id`s and only the the `term_relationships`
 table was joined. The difficulty there is with `get_term_children()` which
 expects and returns only `term_id`s.

 Adding this patch, however, is a good stepping stone to further
 optimizations.

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


More information about the wp-trac mailing list