One of my projects was using a RRD database to store 10-second samples from 20 data streams with a RRD time of 1 year, which works out to around 82 million entr

One of my projects was using a RRD database to store 10-second samples from 20 data streams with a RRD time of 1 year, which works out to around 82 million entries. I display this interactively on a raspberry pi and I used to use RRDTool in python, but switching to my own code leveraging mySQL (and using some judicious rollup tables) means that instead of a larger time span taking ~5 seconds to update, it is now fast enough to give me 20fps no matter the viewed range. Not sure DuckDB will provide any benefit to my specific case, but I'll check it out.