[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:  Performance  |     Version:  3.5.1
 Severity:  normal       |  Resolution:
 Keywords:               |
-------------------------+------------------------------
Description changed by SergeyBiryukov:

Old description:

> The query executed in meta_form() in wp-admin/includes/template.php took
> over 5 seconds to execute on my largest wordpress installation. I changed
> it to use a NOT BETWEEN to enable MySQL to execute the query by just
> using a small part of the meta_key index. My new query executes in less
> than 10 milliseconds.
>
> Here is the improved query:
> SELECT DISTINCT meta_key FROM wp_postmeta
> WHERE meta_key NOT BETWEEN '_' AND '_z'
> HAVING meta_key NOT LIKE '\_%'
> ORDER BY meta_key

New description:

 The query executed in meta_form() in wp-admin/includes/template.php took
 over 5 seconds to execute on my largest wordpress installation. I changed
 it to use a NOT BETWEEN to enable MySQL to execute the query by just using
 a small part of the meta_key index. My new query executes in less than 10
 milliseconds.

 Here is the improved query:
 {{{
 SELECT DISTINCT meta_key FROM wp_postmeta
 WHERE meta_key NOT BETWEEN '_' AND '_z'
 HAVING meta_key NOT LIKE '\_%'
 ORDER BY meta_key
 }}}

--

--
Ticket URL: <http://core.trac.wordpress.org/ticket/24498#comment:1>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software