Changeset 24614

Timestamp:

07/09/2013 07:14:33 PM (12 years ago)

Author:

nacin

Message:

In populate_options(), only query the option names we are checking against. No need to load the entire table into memory. props leewillis77. fixes #24620.

File:

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

trunk/wp-admin/includes/schema.php

@@ -495 +495 @@
     $fat_options = array( 'moderation_keys', 'recently_edited', 'blacklist_keys', 'uninstall_plugins' );
 
-    $existing_options = $wpdb->get_col("SELECT option_name FROM $wpdb->options");
+    $keys = "'" . implode( "', '", array_keys( $options ) ) . "'";
+    $existing_options = $wpdb->get_col( "SELECT option_name FROM $wpdb->options WHERE option_name in ( $keys )" );
 
     $insert = '';