The following SQL query uses "NOT IN" and takes a long time to process if there are a large number of comments. Can you improve it?
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( ( comment_approved = '0'
OR comment_approved = '1' ) )
AND comment_post_ID = 22849
AND comment_type NOT IN ('wpdiscuz_sticky')
AND comment_parent = 0
ORDER BY wp_comments.`comment_ID` asc
LIMIT 0,11
WpdiscuzCore->_getWPComments()
wp-content/plugins/wpdiscuz/class.WpdiscuzCore.php:827WpdiscuzCore->getWPComments()
wp-content/plugins/wpdiscuz/class.WpdiscuzCore.php:774
The following query is also slow.
WpdiscuzCore->getStickyComments():
SELECT SQL_CALC_FOUND_ROWS wp_comments.comment_ID
FROM wp_comments
WHERE ( ( comment_approved = '0'
OR comment_approved = '1' ) )
AND comment_post_ID = 23016
AND comment_type IN ('wpdiscuz_sticky')
AND comment_parent = 0
ORDER BY wp_comments.`comment_ID` asc
When I create "comment_type" index on "comments" table, WpdiscuzCore->getStickyComments() improves the speed, but the first query I presented does not improve the speed. Probably because using "NOT IN".
And I don't want to create a "comment_type" index, because I never use "stick" and there are no "wpdiscuz_sticky" comments in the "comments" table.
