Support » Your WordPress » slow in approving comments

  • I migrate from Blogger to a WordPress a huge blog which had 21k posts and 650k comments and I’m having problems with slow to approve comments. It takes 10 seconds to 1 minute to moderate its.

    Actually the tables are InnoDB, MyISAM can be converted to solve this problem?

    I have activated the slow query log and the query

    “SELECT SQL_CALC_FOUND_ROWS * FROM wp_2_comments WHERE (comment_approved = ‘0’ OR comment_approved = ‘1’ ) ORDER BY comment_post_ID DESC, comment_date_gmt
    DESC LIMIT 0, 25;”

    takes 10 seconds to execute.

    Someone already had this problem? Can you help me?


  • The topic ‘slow in approving comments’ is closed to new replies.