Temperature measurement performance and bugs
Posted: Fri Mar 17, 2023 9:45 am
I've been running Homeautomation for over a year, really like it! One thing that is not quite working the way it is intended though I believe is the temperature measurements. I just upgraded to HA 3.1.1 but the problems remain. The biggest issue is performance, I have three temperature + humidity sensors, and after running HA for a bit less than a year the temps table now contains about 650K rows. Due to the amount of data and how the readings for the measurements page gets calculated this started to cause issues a couple of months back, when the page just went blank. Found that PHP was running out of memory, so despite it not being a very viable long-term solution I changed from the standard memory_limit = 128M to 150M and now more recently 160M to get the page to render. It used to be really slow to load, but after switching to HA 3.1.1 it at least loads quicker. Are there any thoughts on how data can be aggregated long-term in an RRD-like fashion to prevent it from getting out of hand, or to aggregate it in the database as it grows to reduce the memory footprint? I saw the recent changes in 3.1 to prevent the same value from getting entered repeatedly which should help, but the amount of data will still grow over time, especially with a larger number of sensors.