A lot of wp_options entries

Every post should have a corresponding transient value (stored in _transient_view_count_post_id). That’s to be expected. This is how the plugin tells not to update the view count immediately on every page load (to limit requests to the WordPress Stats API).

WordPress doesn’t remove expired transients for whatever reason. You could google “wordpress delete expired transients” and look into options for removing them if you want them gone.

Instead of using transients, the plugin could be coded to store a value in the post meta that tells not to update the view count and then the value could get removed via wp_schedule_event. I’m not sure how the performance would be with that approach. Could be better or worse.

Thanks Adam. I have found this plugin https://www.ads-software.com/plugins/delete-expired-transients/

It makes a good work deleting expired transients, although it has to be manually done.

Would it be difficult to integrate this and make it run scheduled?

>Would it be difficult to integrate this and make it run scheduled?

Well, from the plugin description: “Delete Expired Transients schedules a daily task to delete any expired transients from the options table.”

So I guess it can be set up to remove them automatically. I won’t be integrating it into this plugin though.