Count Query data in a large collection

Ali_Sadain_Tanvir · 2024-08-14T11:49:32.481Z

I have a very large dataset. (60M+)

Now I want to count the query data. I using collection.countDocuments(query) but it is slow

In my next js app, I wanna filter data like country and wanna show how much total data in that country.
How to retrieve the result faster??

steevej · 2024-08-15T12:10:42.114Z

Please share your query and the supporting indexes.

The computed pattern might be of interest.

steevej · 2024-08-20T12:50:04.594Z