Im creating a program that is fetching data from an API to display that data in an easy to read format but I also want to save that data for later use.
The API gives me a random set of numbers and a few other True/False fields plus a timestamp. I was looking into using timeseries to sort the data, but after reading about it I found some forum posts that said timeseries sort could be quite slow for very large amounts of documents. (For reference the API gives out data every 2-2.5 minutes and goes back a few years, so it would be roughly 1 million documents (But I will definitely not end up with that many)) What would be a way to sort loads of data by its timestamp quickly.
[I am new to the forums so apologies if this is in the wrong place]