Our wp_comments has millions of rows.
When we load
/wp/wp-admin/edit-comments.php it would timeout.
Looking at mysql, this simple query is taking a long time
SELECT wp_comments.comment_ID FROM wp_comments WHERE ( ( comment_approved = '0' OR comment_approved = '1' ) ) AND comment_type IN ('pingback', 'trackback') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,1;
Is there away to edit the
edit-comments.php comment dashboard to work only on comments for the last year instead of every commens in the table?