Changeset 11132

Timestamp:

04/29/2009 11:32:53 PM (17 years ago)

Author:

ryan

Message:

Avoid expensive NOT LIKE query. Filter in php instead.

File:

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

trunk/wp-admin/includes/template.php

@@ -2450 +2450 @@
         SELECT meta_key
         FROM $wpdb->postmeta
-        WHERE meta_key NOT LIKE '\_%'
         GROUP BY meta_key
         ORDER BY meta_key
         LIMIT $limit" );
-    if ( $keys )
+    if ( $keys ) {
+        function filter_private_keys($key) {
+            return ( 0 === strpos($key, '_') ) ? false : true;
+        }
+        $keys = array_filter($keys, 'filter_private_keys');
         natcasesort($keys);
+    }
 ?>
 <p><strong><?php _e( 'Add new custom field:' ) ?></strong></p>