Hi Community,
I am creating a view on the deltaCom collection with a filter condition on the entryTs field (which already has an index). The filter condition includes data spanning more than 15 months.
The deltaCom collection contains around 300 million documents, but it takes too much time to load the view in Compass.
I am using MongoDB Community Edition 8.
Could you please suggest the optimal way to handle this?