Changeset 10447 for trunk/wp-admin/includes/upgrade.php

Timestamp:

01/27/2009 10:35:21 PM (16 years ago)

Author:

ryan

Message:

Optimize maybe_create_table(). Props jamescollins. fixes #8977

File:

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

trunk/wp-admin/includes/upgrade.php

@@ -927 +927 @@
 function maybe_create_table($table_name, $create_ddl) {
     global $wpdb;
-    foreach ($wpdb->get_col("SHOW TABLES",0) as $table ) {
-        if ($table == $table_name) {
-            return true;
-        }
-    }
+    if ( $wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name )
+        return true;
     //didn't find it try to create it.
     $q = $wpdb->query($create_ddl);
     // we cannot directly tell that whether this succeeded!
-    foreach ($wpdb->get_col("SHOW TABLES",0) as $table ) {
-        if ($table == $table_name) {
-            return true;
-        }
-    }
+    if ( $wpdb->get_var("SHOW TABLES LIKE '$table_name'") == $table_name )
+        return true;
     return false;
 }