[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
--------------------------+-----------------------------
Changes (by pento):

 * keywords:  has-patch dev-feedback => has-patch


Comment:

 I like this direction alot.

 For escaping, `"'" . implode( "', '", esc_sql( $audio_mime_types ) ) .
 "'"` will do the job.

 For performance testing, please test with MySQL 5.0 and 5.7, with InnoDB
 and MyISAM. If there are any discrepancies, we can dig deeper into
 differences between versions or engines.

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