slow in approving comments (1 post)

  1. mhonorio
    Posted 7 years ago #

    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?


Topic Closed

This topic has been closed to new replies.

About this Topic