Initial page load of sensor reading dashboard slows down with ~100k+ readings #5
Description
When there are 100k or more sensor readings in the DB, the initial page load of the dashboard noticeably slows, particularly:
- The average temperature over the last 24 hrs chart
- The average humidity over the last 24 hrs chart
Once getting into the multiple hundreds of thousands of sensor readings in the DB, these charts will take several seconds to load when the DB and backend are running on a Raspberry Pi 4.
Desired Functionality
This page load performance should not degrade with the number of sensor readings in the DB. It should always take the same amount of time no matter how many values are in the DB.