Using findOne in mongodb to get element with max id

by

You should use find, like you already are, and not aggregation which will be slower since it needs to scan all the values of _id fields to figure out the max.

As comments pointed out there is no difference between using find() and findOne() – functionally or elegance-wise. In fact, findOne in the shell (and in the drivers which implement it) is defined in terms of find (with limit -1 and with pretty print in the shell).

If you really want to do the equivalent of

db.collection.find().sort({_id:-1}).limit(1).pretty()

as findOne you can do it with this syntax:

db.collection.findOne({$query:{},$orderby:{_id:-1}})

More Related Contents:

  1. How to remove a field completely from a MongoDB document?
  2. How to Model a “likes” voting system with MongoDB
  3. Understanding MongoDB BSON Document size limit
  4. MongoDB – admin user not authorized
  5. How can I run MongoDB as a Windows service?
  6. Overflow sort stage buffered data usage exceeds internal limit
  7. Slow pagination over tons of records in mongodb
  8. MongoDB – paging
  9. mongo.exe not installed in Version 6.0.0
  10. multiple instances of Mongo DB on same server
  11. How can I share MongoDB collections between Meteor apps?
  12. MongoDb shuts down with Code 100 [closed]
  13. Mongodb Query To select records having a given key
  14. MongoDB – What about Decimal type of value?
  15. MongoDB $or query
  16. Is shortening MongoDB property names worthwhile?
  17. Can mongodb be used as an embedded database?
  18. convert iso date to timestamp in mongo query
  19. Using $slice operator to get last element of array
  20. Simple HTTP/TCP health check for MongoDB
  21. Save Subset of MongoDB Collection to Another Collection
  22. Meteor method vs. deny/allow rules
  23. MongoDB via Mongoose JS – What is findByID?
  24. Find largest document size in MongoDB
  25. mongo: command not found on mongodb 6.0 docker container [duplicate]
  26. Mongodb: Perform a Date range query from the ObjectId in the mongo shell
  27. MongoDB server can still be accessed without credentials
  28. What is the use of the mongo.lock file?
  29. Mongodb, aggregate query with $lookup
  30. Mongo unique index case insensitive

Leave a Comment