Can someone suggest to me how to structure the MongoDB database, when I have multiple unique sensors and I am capturing data from these sensors for 24 hours daily after every 10 minutes?
Currently, I am creating a separate collection for each sensor data which has multiple documents of sensor data reading after every 10 minutes.
But at one point the number of collections is going to increase massively. Then how can I possibly reduce the number of collections generated? How to model these collections so that performance will not degrade? Please note each collection will have multiple documents with timestamp and it’s reading.