[wp-trac] [WordPress Trac] #28922: Post update caches queries causes "Using temporary" and "Using filesort"

[WordPress Trac]

#28922: Post update caches queries causes "Using temporary" and "Using filesort"
-------------------------+---------------------------
 Reporter:  mbrandys     |       Owner:  boonebgorges
     Type:  enhancement  |      Status:  assigned
 Priority:  normal       |   Milestone:  4.4
Component:  Cache API    |     Version:  3.9.1
 Severity:  normal       |  Resolution:
 Keywords:  has-patch    |     Focuses:
-------------------------+---------------------------
Changes (by wonderboymusic):

 * keywords:   => has-patch
 * owner:   => boonebgorges
 * status:  new => assigned
 * milestone:  Awaiting Review => 4.4


Comment:

 In `update_object_term_cache()`, there is no need to order by `name`.
 Without it, query plan goes from `Using temporary; Using filesort; Using
 index` to `Using index; Using join buffer`

 [attachment:28922.diff 28922.diff]

--
Ticket URL: <https://core.trac.wordpress.org/ticket/28922#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform