[wp-trac] [WordPress Trac] #5137: Taxonomy intersection queries are inefficient

WordPress Trac wp-trac at lists.automattic.com
Wed Oct 3 18:58:45 GMT 2007


#5137: Taxonomy intersection queries are inefficient
---------------------+------------------------------------------------------
 Reporter:  ryan     |       Owner:  anonymous           
     Type:  defect   |      Status:  new                 
 Priority:  normal   |   Milestone:  2.3.1               
Component:  General  |     Version:  2.3                 
 Severity:  normal   |    Keywords:  taxonomy performance
---------------------+------------------------------------------------------
 Performing intersection queries by equating like attributes is very
 inefficient when  intersecting more than a few terms.  Let's use the
 method where we perform a union query, count the number of terms for each
 post, and fetch the posts that have all terms.

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


More information about the wp-trac mailing list