[wp-trac] [WordPress Trac] #32264: wp_enqueue_media() is slow on large sites

[WordPress Trac]

#32264: wp_enqueue_media() is slow on large sites
-------------------------------+------------------------------
 Reporter:  philipjohn         |       Owner:
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Posts, Post Types  |     Version:  3.9
 Severity:  normal             |  Resolution:
 Keywords:                     |     Focuses:  performance
-------------------------------+------------------------------

Comment (by mintindeed):

 @wonderboymusic helped do some debugging on this issue. The problem is on
 a site with 1.7 million attachments and 0 audio or video attachments, this
 query has to do a ginormous table scan using a query that is not able to
 take advantage of existing indexes. His suggestion was to add an index to
 post_mime_type which reduces this query from taking several seconds, down
 to milliseconds.

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