[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 wonderboymusic):

 because it's finding audio files before video files when doing the full
 table scan - purely coincidental based on the order they were added

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