Recent Comments not refreshing!

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?

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

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.

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.

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:

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

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

http://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.