Hi,
I have been using your plugin to log most everything in HS, including my 32 channels of energy meter data every 8 seconds. Everything worked fine for a while, but then it got slower and slower to create a chart until it was not working at all. The only thing I could do was to kill the db file and start over and everything is again working fine.
Would it be possible to add an option to the plugin to connect to a remote database like mysql/MariaDB?
If not, maybe you could store the data in a different DB file monthly; of course this would complicate the query logic, but might work around the performance issues.
Thanks,
Mike
I have been using your plugin to log most everything in HS, including my 32 channels of energy meter data every 8 seconds. Everything worked fine for a while, but then it got slower and slower to create a chart until it was not working at all. The only thing I could do was to kill the db file and start over and everything is again working fine.
Would it be possible to add an option to the plugin to connect to a remote database like mysql/MariaDB?
If not, maybe you could store the data in a different DB file monthly; of course this would complicate the query logic, but might work around the performance issues.
Thanks,
Mike
Comment