Make WordPress Core

Changeset 8814


Ignore:
Timestamp:
09/05/2008 03:46:56 PM (16 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.