[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:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Administration           |     Version:  4.3.1
 Severity:  critical                 |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+-----------------------------

Comment (by jb510):

 If we can't/shouldn't truncate the column it seems like the best the
 answer is to not make the query in the first place.  Either but reverting
 to a text field as John Billion suggested above, or not loading the
 metabox itself unless explictly wanted.

 Would lazy loading that box or just lazy loading the drop down be viable?

 Are we past the everything must work in a nojs world? Maybe Ajax/lazy load
 the drop down when focused, but for nojs just leave a text input?

 FWIW we just disable that box via filter on all sites globally now and
 have had no issues.

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