[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:  closed
 Priority:  normal       |   Milestone:  4.4
Component:  Cache API    |     Version:  3.9.1
 Severity:  normal       |  Resolution:  fixed
 Keywords:  has-patch    |     Focuses:
-------------------------+---------------------------

Comment (by boonebgorges):

 In [changeset:"36056"]:
 {{{
 #!CommitTicketReference repository="" revision="36056"
 Order terms by 'name' when populating object term cache.

 [34217] removed the `ORDER BY` clause from `update_object_term_cache()`,
 for
 improved performance. But this proved to cause problems in cases where
 users
 were expecting the results of `get_the_terms()` to be ordered by 'name'.
 Let's
 revert the change for the time being, and look into more disciplined
 ordering
 in a future release.

 Props afercia.
 See #28922. Fixes #35180.
 }}}

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