Random record from MongoDB

Question

I am looking to get a random record from a huge (100 million record) mongodb.

What is the fastest and most efficient way to do so? The data is already there and there is no field in which I can generate a random number and obtain a random row.

Any suggestions?

Answer 1

To know about the random record from MongoDB you can count all records and generate a random number between 0 and the count, and then do:

db.yourCollection.find().limit(-1).skip(yourRandomNumber).next()