The 7Gb was before I found the problem. It’s now 29Mb with 7 days of data. I have 2 Synology nas drives and a Synology router. These both have tons of sensors which home assistant recorded constantly along with all my other devices. The DB was getting 5Mb per second, my nas was going mental keeping up which is why I noticed the problem.
Fixing the recorder corrected any response issues.
I’ll be adding more entities to the “include” section but hopefully the DB will be less than 100Mb.
For the record I have 14 sonoff switches, 2 sonoff led controllers, an RF bridge, 12 Honeywell evohome zones (14 rad stats) plus hot water controller, 4 echo dots, person tracking is by phones on the Synology router, 2 foscam cameras, PS4 and some media players and a few other devices. I’m running motion eye on the pi plus a few other integrations. The processor is rarely above 20% load so should be good for plenty expansion.