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

 Further testing makes me suspect the patch isn't making a material
 difference. There's also a curious difference between the speed of the
 audio and video queries.

 On a live site with a substantial posts table I've seen the following:

 Without patch:
 * audio query: ~3ms
 * video query: ~700ms

 With patch:
 * audio query: ~3ms
 * video query: ~700-2000ms

 So;

 1. My patch does nothing to improve the queries
 2. It's not clear to me why the video query is consistently much slower

 I've also attempted to use a more convoluted "OR" query as opposed to "IN"
 for the video query but there was no difference in speed.

 Where does this leave us? I'm not sure of other ways we could improve this
 query, so does that bring us back to indexes?

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