We have a very big collection, and for getting a better performance, we want to limit the size of "active" collection.
That means, we have two collection: "active" and "inactive", we need to keep the data of last 90 days in "active" collection, and move the data before 90 days to "inactive" collection automatically.
Is any way that we can do this automatically with mongodb?
Or is there any other solution we can achieve this target? (get better performance for querrying data in 90 days without deleting old data)