[wp-trac] [WordPress Trac] #14699: Optimize SQL resulting from custom taxonomy queries
WordPress Trac
wp-trac at lists.automattic.com
Thu Aug 26 01:12:58 UTC 2010
#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
More information about the wp-trac
mailing list