[wp-trac] [WordPress Trac] #18081: Improve performance of taxonomy queries, avoid temporary tables

[WordPress Trac]

#18081: Improve performance of taxonomy queries, avoid temporary tables
-------------------------+-----------------------------
 Reporter:  tott         |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Taxonomy     |    Version:
 Severity:  normal       |   Keywords:
-------------------------+-----------------------------
 In various taxonomy queries "IN ( value )" is used even if there is only
 one value to check against. This is in some cases causing there creation
 of temporary db tables and bad performing queries.

 The attached patch will ensure that only when there are more than one
 values to be added a "IN" statement is used. Otherwise a " = value"
 statement is performed.

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