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

 I don't think caching will work either. Firstly, it'd bring the
 infrastructure to its knees just to build that cache. Which I think would
 time out before hand. The queries quickly backed up and were processing at
 20seconds (with 4 x `db.r4.xlarge` readers).

 Secondly, if that cache was cleared for whatever reason, back to problem 1
 again and bring a production platform down unexpectedly.

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