[wp-trac] [WordPress Trac] #33296: Allow sites to skip a query in meta_form() that can delay loading the page

[WordPress Trac]

#33296: Allow sites to skip a query in meta_form() that can delay loading the page
-------------------------------------------------+-------------------------
 Reporter:  kitchin                              |       Owner:  (none)
     Type:  enhancement                          |      Status:  new
 Priority:  normal                               |   Milestone:
Component:  Administration                       |     Version:  4.3
 Severity:  normal                               |  Resolution:
 Keywords:  has-patch needs-refresh needs-unit-  |     Focuses:
  tests                                          |  performance
-------------------------------------------------+-------------------------
Changes (by peterwilsoncc):

 * keywords:  has-patch => has-patch needs-refresh needs-unit-tests


Comment:

 This was discussed in a triage session today.

 Avoiding connecting to the database for a `LIMIT 0` query makes sense.

 For sites that do set the limit to display zero keys using the
 `postmeta_form_limit` filter, the [https://dev.mysql.com/doc/refman/8.0/en
 /limit-optimization.html MySQL optimizer will skip the reading the table]
 so the sub-optimal where clause won't slow things down.

 [attachment:"33296.patch"] no longer applies cleanly so adding the needs-
 refresh keywords.

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