Changeset 10446

Timestamp:

01/26/2009 10:34:50 PM (15 years ago)

Author:

ryan

Message:

Force the index only for 0 OR 1 queries. see #7415

File:

• trunk/wp-admin/includes/template.php (modified) (3 diffs)

trunk/wp-admin/includes/template.php

@@ -1922 +1922 @@
     $post = (int) $post;
     $count = wp_count_comments();
-
+    $index = '';
+    
     if ( 'moderated' == $status ) {
         $approved = "comment_approved = '0'";
@@ -1935 +1936 @@
         $approved = "( comment_approved = '0' OR comment_approved = '1' )";
         $total = $count->moderated + $count->approved;
+        $index = 'USE INDEX (comment_date_gmt)';
     }
 
@@ -1972 +1974 @@
             $typesql";
     } else {
-        $query = "FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE $approved $post $typesql";
+        $query = "FROM $wpdb->comments $index WHERE $approved $post $typesql";
     }