SQL

How-to and Troubleshooting

Last Post by isrdll 4 years ago

4 Posts

2 Users

0 Reactions

1,172 Views

RSS

Posts: 4

isrdll

Topic starter

Sep 28, 2021 6:46 am

(@isrdll)

Active Member

Joined: 4 years ago

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:827
WpdiscuzCore->getWPComments()
wp-content/plugins/wpdiscuz/class.WpdiscuzCore.php:774

3 Replies

Posts: 8188

Asti

Support

Sep 28, 2021 8:39 am

(@asti)

Illustrious Member

Joined: 8 years ago

We'll discuss this with our team and take it into consideration for future versions.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

2 Replies

isrdll

(@isrdll)

Joined: 4 years ago

Active Member

Posts: 4

Sep 28, 2021 2:11 pm

Reply to

Asti

@asti

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".