Changeset 33390

Timestamp:

07/23/2015 05:16:04 AM (9 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