WordPress.org

Make WordPress Core

Changeset 8814


Ignore:
Timestamp:
09/05/08 15:46:56 (6 years ago)
Author:
ryan
Message:

Lose USE INDEX on comment_date_gmt. It didn't help performance very much and some people are missing the comment_date_gmt index. see #7664 for 2.6

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/2.6/wp-admin/includes/template.php

    r8456 r8814  
    716716            ORDER BY comment_date_gmt DESC LIMIT $start, $num"); 
    717717    } else { 
    718         $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments USE INDEX (comment_date_gmt) WHERE $approved ORDER BY comment_date_gmt DESC LIMIT $start, $num" ); 
     718        $comments = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->comments WHERE $approved ORDER BY comment_date_gmt DESC LIMIT $start, $num" ); 
    719719    } 
    720720 
Note: See TracChangeset for help on using the changeset viewer.