Changeset 33390

Timestamp:

07/23/2015 05:16:04 AM (11 years ago)

Author:

dd32

Message:

Switch to a more performant query in meta_form().

Props lumaraf, swissspidy, rarylson, pento
Fixes #24498

File:

• trunk/src/wp-admin/includes/template.php (modified) (1 diff)

trunk/src/wp-admin/includes/template.php

@@ -678 +678 @@
          */
         $limit = apply_filters( 'postmeta_form_limit', 30 );
-        $sql = "SELECT meta_key
+        $sql = "SELECT DISTINCT meta_key
                 FROM $wpdb->postmeta
-                GROUP BY meta_key
+                WHERE meta_key NOT BETWEEN '_' AND '_z'
                 HAVING meta_key NOT LIKE %s
                 ORDER BY meta_key