Hey all, I’m looking into using time series collections for history tables, and I’m curious if this is a good fit. Our general requirements are:
- we want to be able to snapshot data every day
- for a given date, we will have potentially thousands of sub-documents that we want to store and query
- we want to be able to query (paginated) data with filters for a given date. there also may be a use case in the future to query for a given sub-document across dates
I’ve seen the use cases in the Mongo website, and they seem to be storing very simple data for each date, whereas my use case has more complex data for a given date. is my use case a good match for TSD? thank you!