Those table sizes would scare me!
There’s been a lot of discussion lately about improving the way HA’s Recorder works. Some ideas include splitting off long-term statistics into their own database, improving the way users can manage excluding records, and my own suggestion, allowing the retention period to be specified for individual entities.
I see some great ideas in these threads, and I’m optimistic that the best of them can be implemented to make HA even better. I’d encourage you to review those Feature Requests and vote on any you think would help. And add your own ideas and suggestions.