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

WordPress Trac noreply at wordpress.org
Tue Sep 15 20:52:55 UTC 2015


#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:
-------------------------+---------------------------
Changes (by boonebgorges):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"34217"]:
 {{{
 #!CommitTicketReference repository="" revision="34217"
 Omit the `ORDER BY` clause when updating object term cache.

 The `ORDER BY` clause was forcing filesorts on large tables, and is
 unnecessary, since term order doesn't matter when updating the cache.

 Props mbrandys, wonderboymusic.
 Fixes #28922.
 }}}

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


More information about the wp-trac mailing list