Changeset 13227

Timestamp:

02/19/2010 05:56:40 PM (15 years ago)

Author:

ryan

Message:

Add an index on comment_parent to speed up wp_delete_comment() reparenting queries. fixes #12289

Location:

trunk

Files:

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

trunk/wp-admin/includes/schema.php

@@ -82 +82 @@
   KEY comment_post_ID (comment_post_ID),
   KEY comment_approved_date_gmt (comment_approved,comment_date_gmt),
-  KEY comment_date_gmt (comment_date_gmt)
+  KEY comment_date_gmt (comment_date_gmt),
+  KEY comment_parent (comment_parent)
 ) $charset_collate;
 CREATE TABLE $wpdb->links (

trunk/wp-admin/includes/upgrade.php

@@ -1103 +1103 @@
  */
 function upgrade_300() {
-    populate_roles_300();
-    if ( is_multisite() && is_main_site() && ! defined( 'MULTISITE' ) && get_site_option( 'siteurl' ) === false ) 
-        add_site_option( 'siteurl', '' );
+    global $wp_current_db_version;
+
+    if ( $wp_current_db_version < 12751 ) {
+        populate_roles_300();
+        if ( is_multisite() && is_main_site() && ! defined( 'MULTISITE' ) && get_site_option( 'siteurl' ) === false ) 
+            add_site_option( 'siteurl', '' );
+    }
 }
 

trunk/wp-includes/version.php

@@ -16 +16 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 12751;
+$wp_db_version = 13226;
 
 /**