[wp-trac] [WordPress Trac] #38709: Unlimited query for invalid post names

[WordPress Trac]

#38709: Unlimited query for invalid post names
--------------------------+------------------------------
 Reporter:  david.binda   |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Query         |     Version:  4.6.1
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:  performance
--------------------------+------------------------------
Changes (by mikeschroder):

 * keywords:   => needs-patch
 * component:  Permalinks => Query


Comment:

 Hi @davidbinda!

 Thanks so much for the report, and apologies for the extremely long time
 waiting for a response.

 This ticket was discussed in
 [https://wordpress.slack.com/archives/C02RQBWTW/p1627363690397800 a triage
 session today].

 Investigating, @peterwilsoncc found that this does still seem to be an
 issue, and `an EXPLAIN on that indicates it's using filesort so the
 indexes are missed.`

 Since this seems to be an issue coming from the Query component, going to
 move it there for further attention, and mark this as `needs-patch`.

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