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

 > Both queries return an empty result set.

 This was incorrect - the audio query I'm testing doesn't return an empty
 result set, but the video one does.

 Trying with other sites I'm seeing the queries that return an empty result
 as very slow. If there *are* results, the query is nice and quick.

 Does that point us back to the index as a solution?

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