Changeset 6825

Timestamp:

02/13/2008 07:15:30 PM (18 years ago)

Author:

ryan

Message:

Add comment_date_gmt key to comments table. Optimize _wp_get_comment_list() query. fixes #5785

Location:

trunk

Files:

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

trunk/wp-admin/includes/schema.php

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

trunk/wp-admin/includes/template.php

@@ -557 +557 @@
             comment_content LIKE ('%$s%') ) AND
             comment_approved != 'spam'
-            ORDER BY comment_date DESC LIMIT $start, $num");
+            ORDER BY comment_date_gmt DESC LIMIT $start, $num");
     } else {
-        $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $start, $num" );
+        $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT $start, $num" );
     }
 

trunk/wp-includes/version.php

@@ -17 +17 @@
  * @global int $wp_db_version
  */
-$wp_db_version = 6748;
+$wp_db_version = 6825;
 
 ?>