Commit interval is not going to reduce your database size. All it does is store the state changes in memory and then write them all at once to the SD card after the interval is up. This can help with SD card longevity but will cause your logbook to lag behind (the amount of the interval).
There are only three ways to reduce the database size.
- Reduce the number of keep_days.
- Use more excludes, see How to reduce your database size and extend the life of your SD card
- Store long term data somewhere else. Like InfluxDB, which is better at storing time based data. See Frenk’s tutorial here: https://youtu.be/m9qIqq104as but only include the entities you want in the Influx configuration YAML (rather than everything). it’s the same include/exclude syntax as the recorder.