[wp-trac] [WordPress Trac] #33885: meta_form performs a potentially expensive query

[WordPress Trac]

#33885: meta_form performs a potentially expensive query
-------------------------------------+-------------------------------------
 Reporter:  jorbin                   |       Owner:  (none)
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  6.0
Component:  Administration           |     Version:  4.3.1
 Severity:  critical                 |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  administration,
  needs-unit-tests                   |  performance
-------------------------------------+-------------------------------------

Comment (by chaion07):

 Thanks @jorbin for reporting this. This ticket was reviewed during a
 recent [https://wordpress.slack.com/archives/C02RQBWTW/p1647925574535769
 bug scrub session by the core team]. Here's the feedback received:
 01. change the JOIN part of the query, the approach is similar to #49278
 02. change the meta_key length

 Cheers!

 Props to @hilayt24 & @craigfrancis

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