Recent Comments not refreshing!

This is a known issue.

Do you happen to use a cache plugin, such as WP Super Cache, W3 Total Cache, etc. ?

I have a similar issue, it takes a week or two to show the latest.
I do use W3 Total Cache, how can I fix this?

@pbure I believe you also use Page Cache feature of W3 TC? When you see a cached page the plugin isn’t called at all so the comment list is not re-generated.

Version 2.0.0 of BWP Recent Comments will refresh itself from the browser in order to resolve this issue.

Please follow updates to such feature here: https://github.com/OddOneOut/bwp-recent-comments/issues/22

Yes it’s on by default. I’ll empty the cache for now and wait for v2 to come out.

I have the same problem. It works a day or two and then it stops updating for some reason. Disabling and enabling the plugin solves it for a few days.

I use WP SuperCache.

Do you have any estimate for when 2.0 will be relased?

@TheArchturian yeah that’s the same issue with page cache plugin. I’m already working on v2 and will try to release it as soon as I can.

Sounds great, Khang! Looking forward to it.

I have, as many other WordPress users, categories that I use as subpages just like the front page, but filtered on the specific category. It would be great if Better WordPress Recent Comments could have an selection to show comments from a spesific post category.

That way I would be able to show comments only from the category page I’m watching and make the category page filtered on its spesific content. If that is possible to implement, it would make me very happy as it will encourage more people to comment and refresh older comments with life again. We have a lot of people using your plugin actively. I’m sure our readers would love this filtering feature.

That feature is already implemented in my dev version, please follow updates here: https://github.com/OddOneOut/bwp-recent-comments/issues/4

Cool, thanks for the feedback!

By the way, I’m optimizing the queries against MySQL and see that your Widget uses 1.25 sec to query the db:

# Query_time: 1.265625 Lock_time: 0.000000 Rows_sent: 6 Rows_examined: 288634
SET timestamp=1443741678;
SELECT wpcoms.*
FROM (
SELECT *,
@num := if(@post_id = comment_post_ID, @num + 1, 1) as

row_number,
@post_id := comment_post_ID as cpID
FROM wp_comments
WHERE comment_approved = 1 ORDER BY comment_post_ID DESC,

comment_ID DESC
) as wpcoms
WHERE wpcoms.row_number <= 2
ORDER BY wpcoms.comment_date DESC
LIMIT 6;

Is there any way you/I can enhance this query as 1.25 seconds is a lot. Thanks.

The comments grouped by post feature is expected to be slow, especially when you have that many comments. The query is different in the next version but I’m not confident that it will be faster, but will let you know when a beta version is ready.

Thanks for your feedback, Khang.

In the times of internet today, a rendering of a full page should not take more than the one query itself as the next website is just a click away. I love the visual presentation of your plugin, it is just perfect for my need, but if the query still will use that much time, I must choose a different one.

I don’t have enough SQL experience myself, but I’m sure the query could be improved from 1.2 seconds to something more normal like 0.0001 seconds. Rows examined says 288.634, but my database consists of only 96.000 comments. That surely should be possible to improve so that just a few comments actually is examined in a very short time instead as there is only the few recent posted comments it shows.

Maybe you could ask around at stackoverflow.com where I found how to log slow queries. It seems to be a lot of people with good knowledge there:

https://stackoverflow.com/questions/2403793/how-can-i-enable-mysqls-slow-query-log-without-restarting-mysql

Btw, I can test the new query on my MySQL database if you like, to see if there is an improvement.

The guys at Stackoverflow.com has some suggestions for you for a faster query:

https://stackoverflow.com/questions/32915411/optimize-slow-query-in-wordpress-plugin-better-wordpress-recent-comments

If you join the thread I’m sure you will end up with an optimal query.

Thank you for your effort. Have you tried adding more compound indexes as this answer https://stackoverflow.com/a/32916748 suggested?