Mongo DB - fastest way to retrieve 5 Million records from a collection

Question

I am using MongoDB in our project and I'm currently learning how things work

I have created a collection with 5 million records. When i fire the query db.ProductDetails.find() on the console it takes too much time to display all the data.

Also when i use the following code in C#

var Products = db.GetCollection("ProductDetails").FindAll().Documents.ToList();

the system throws OutOfMemoryException after some time..

Is there any other faster or more optimized way to achieve this ?

Answer 1

Never try to fetch all entries at the same time. Use filters or get a few rows at a time.

Read this question: MongoDB - paging