[wp-trac] [WordPress Trac] #31071: post_mime_type related queries still slow on larger sites

[WordPress Trac]

#31071: post_mime_type related queries still slow on larger sites
--------------------------+-----------------------------
 Reporter:  archon810     |       Owner:  pento
     Type:  defect (bug)  |      Status:  assigned
 Priority:  normal        |   Milestone:  Future Release
Component:  Media         |     Version:  4.1
 Severity:  normal        |  Resolution:
 Keywords:  has-patch     |     Focuses:  performance
--------------------------+-----------------------------

Comment (by philipjohn):

 Thanks @archon810 !

 I've tested with MySQL 5.7 and both InnoDB and MyISAM on trunk with the
 patch applied and have seen no issues. Both queries are consistently
 taking fewer than 0.5ms to complete.

 However, I'm struggling to test on 5.0. I'm mostly trying to change the
 version within VVV. If anyone can point me to a reliable method for
 running tests on versions as old as 5.0 that'd be appreciated.

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