wp_comments table really big casuing /wp-admin/edit-comments.php to slowly load

7 months ago 45

Our wp_comments has millions of rows.

When we load /wp/wp-admin/edit-comments.php it would timeout.

Looking astatine mysql, this elemental query is taking a agelong 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 determination distant to edit the edit-comments.php remark dashboard to enactment lone connected comments for the past twelvemonth alternatively of each commens successful the table?

Read Entire Article

Our Ventures