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

[WordPress Trac]

#14699: Optimize SQL resulting from custom taxonomy queries
--------------------------+-------------------------------------------------
 Reporter:  misterbisson  |       Owner:                            
     Type:  defect (bug)  |      Status:  new                       
 Priority:  normal        |   Milestone:  Awaiting Review           
Component:  Query         |     Version:  3.0.1                     
 Severity:  normal        |    Keywords:  query, mysql, optimization
--------------------------+-------------------------------------------------
 The SQL generated by `WP_Query::get_posts()` results in a
 `get_objects_in_term()` and `implode()`s the given post IDs into the posts
 query. The query can't be optimized at the database layer, and leads to
 slow performance with large numbers of posts.
 [http://core.trac.wordpress.org/browser/trunk/wp-
 includes/query.php?rev=15531#L1968 browse code]

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