[wp-trac] [WordPress Trac] #24498: Improving performance of meta_form()

[WordPress Trac]

#24498: Improving performance of meta_form()
----------------------------+------------------------------
 Reporter:  lumaraf         |       Owner:
     Type:  enhancement     |      Status:  new
 Priority:  normal          |   Milestone:  Awaiting Review
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+------------------------------

Comment (by pross):

 Just to chime in with testing results on a site with 2.5M postmeta rows...

 The default query takes 6.85s

 This takes 1.58s:

 {{{
 SELECT DISTINCT meta_key
 FROM wp_postmeta
 WHERE meta_key NOT LIKE '\\_%'
 ORDER BY meta_key
 limit 30
 }}}

 And the proposed patch 24498.patch takes 2.5s

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