MariaDB/SQL query gotcha and optimized solution (#E18)
Haven’t had a general advice post for a while, have we.
My small fleet of ESP32 boards across the apartment is still gathering information for the AVM Fritz DECT 301 radiator control units that just started the heating season. While their queries are really simple, quick and fully automated, I also have an HighCharts overview plot of all data with user-defined query depth, usually 300 minutes / 5 hours, but I think there’s no arbitrary limit to it. One could plot all 2 million rows of data…but I’m not gonna try.
Anyway, I recently noticed query times went up significantly, and the whole thing never was blazing fast in the first place. […]
[…] Someone’s busy, so here’s a lame, lazy follow-up post to the Panasonic backlight “fix” from WHL #84: […]