[wp-trac] [WordPress Trac] #41281: attachment_url_to_postid results in very slow query

[WordPress Trac]

#41281: attachment_url_to_postid results in very slow query
------------------------------+------------------------------
 Reporter:  Takahashi_Fumiki  |       Owner:  joemcgill
     Type:  enhancement       |      Status:  accepted
 Priority:  normal            |   Milestone:  Awaiting Review
Component:  Database          |     Version:  4.9
 Severity:  normal            |  Resolution:
 Keywords:                    |     Focuses:  performance
------------------------------+------------------------------

Comment (by Takahashi_Fumiki):

 I agree with @archon810 because cache itself is not a fundamental
 solution.
 Without index on `meta_value`, it may take over 60 seconds just for one
 query with a large volume of posts.
 MySQL will hang up with requests in rapid succession, so there's no chance
 to hold cache and use it.

 Since more than 10 years have been passed from WordPress' first release,
 WP sites with 100,000 posts are common.

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