[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:  closed
 Priority:  normal       |   Milestone:
Component:  Taxonomy     |     Version:  3.2
 Severity:  normal       |  Resolution:  invalid
 Keywords:  westi-likes  |
-------------------------+----------------------
Changes (by wonderboymusic):

 * keywords:  westi-likes needs-patch => westi-likes
 * status:  new => closed
 * resolution:   => invalid
 * milestone:  Future Release =>


Comment:

 The `GROUP BY` is what causes the temp table, the `ORDER BY` causes the
 `Using filesort` - the `IN` vs `=` makes seemingly no difference

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