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?