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>