Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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.
