Changeset 6729

Timestamp:

02/05/2008 06:04:17 PM (19 years ago)

Author:

ryan

Message:

Add key on comment_approved,comment_date to speed up last comment modified queries. fixes #5773

Location:

trunk

Files:

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

trunk/wp-admin/includes/schema.php

@@ -53 +53 @@
   PRIMARY KEY  (comment_ID),
   KEY comment_approved (comment_approved),
-  KEY comment_post_ID (comment_post_ID)
+  KEY comment_post_ID (comment_post_ID),
+  KEY comment_approved_date (comment_approved,comment_date)
 ) $charset_collate;
 CREATE TABLE $wpdb->links (

trunk/wp-includes/comment.php

@@ -208 +208 @@
         switch ( strtolower($timezone)) {
                 case 'gmt':
-                        $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");
+                        $lastcommentmodified = $wpdb->get_var("SELECT comment_date_gmt FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date DESC LIMIT 1");
                         break;
                 case 'blog':
-                        $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT 1");
+                        $lastcommentmodified = $wpdb->get_var("SELECT comment_date FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date DESC LIMIT 1");
                         break;
                 case 'server':

trunk/wp-includes/version.php

@@ -17 +17 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 6689;
+$wp_db_version = 6730;
 
 ?>