Depends on how many users you have, but it’s probably fine. You could also just keep a running count of comments made by registered user, and add when they comment / subtract when a comment of them gets deleted or rejected / marked as spam.
is using “require_once” in wordpress theme affect the speed ???
Why are the latest visits to my website originating from my own website?
Serve cookie free URLs in WordPress without using a CDN
REST api v2 how can modify respond types and make custom DTO for better performance
WP_Term_Query->get_terms() very slow query for WordPress filter
You can use wp->query calls to loop through the users table and update each row in a loop. Probably would need to use cron jobs for this, this is different for every host but you basically would tell it to run your php script at intervals.
I’ve recently done a batch import of about 200 posts, with 5 taxonomies attached to them and each of the posts a few terms. It took about 5-10 seconds to do the whole batch. So no, it shouldn’t be this slow.
Can lots of tags affect performance?
get_template_part calls amount and performance?