Plugin uses post_date_gmt, which is not indexed

The current version of the plugin (2013.0730.7777) uses the post_date_gmt database field:

SELECT ID FROM {$wpdb->posts} WHERE ( ( post_date_gmt > 0 && post_date_gmt <= %s ) ) AND post_status = ‘future’ LIMIT 0,10

For large installations, this is very very very slow, as the “post_date_gmt” field does not have an index.

The following would be much better:

SELECT ID FROM {$wpdb->posts} WHERE ( ( post_date > 0 && post_date <= %s ) ) AND post_status = ‘future’ LIMIT 0,10

…

$sql = $wpdb->prepare( $qry, current_time( ‘mysql’, 0 ) );

http://ww.wp.xz.cn/plugins/wp-missed-schedule/