[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:  rhurling
     Type:  enhancement                          |      Status:  assigned
 Priority:  normal                               |   Milestone:  Awaiting
Component:  Posts, Post Types                    |  Review
 Severity:  normal                               |     Version:  3.9
 Keywords:  good-first-bug has-patch needs-      |  Resolution:
  testing                                        |     Focuses:
                                                 |  performance
-------------------------------------------------+-------------------------

Comment (by birgire):

 I wonder if we should introduce the `has_audio` and `has_video` counters
 (in the options table) instead of using SQL queries at all?

 These counters could be updated when we upload or delete audio/video
 files.

 This could of course introduce potential sync problems, but that might not
 be more difficult to handle then dealing with these potential slow SQL
 queries.

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