How to query MongoDB to test if an item exists?

by

Since you don’t need the count, you should make sure the query will return after it found the first match. Since count performance is not ideal, that is rather important. The following query should accomplish that:

db.Collection.find({ /* criteria */}).limit(1).size();

Note that find().count() by default does not honor the limit clause and might hence return unexpected results (and will try to find all matches). size() or count(true) will honor the limit flag.

If you want to go to extremes, you should make sure that your query uses covered indexes. Covered indexes only access the index, but they require that the field you query on is indexed. In general, that should do it because a count() obviously does not return any fields. Still, covered indexes sometimes need rather verbose cursors:

db.values.find({"value" : 3553}, {"_id": 0, "value" : 1}).limit(1).explain();

{
  // ...
  "cursor" : "BtreeCursor value_1",
  "indexOnly" : true,  // covered!
}

Unfortunately, count() does not offer explain(), so whether it’s worth it or not is hard to say. As usual, measurement is a better companion than theory, but theory can at least save you from the bigger problems.

More Related Contents:

  1. How to execute mongo commands through shell scripts?
  2. pushing object into array schema in Mongoose
  3. How to copy a collection from one database to another in MongoDB
  4. What is the default database path for MongoDB?
  5. How to aggregate sum in MongoDB to get a total count?
  6. mongo – couldn’t connect to server 127.0.0.1:27017
  7. Merging two collections in MongoDB
  8. What is the best way to store dates in MongoDB?
  9. Matching ObjectId to String for $graphLookup
  10. How to work around the lack of transactions in MongoDB?
  11. MongoDB-CR Authentication failed
  12. Rounding to 2 decimal places using MongoDB aggregation framework
  13. MongoDB – Update or Insert object in array
  14. Why does direction of index matter in MongoDB?
  15. How can I update multiple documents in mongoose?
  16. Matching an array field which contains any combination of the provided array in MongoDB
  17. MongoDB lookup when foreign field is an array of objects
  18. Get the latest record from mongodb collection
  19. Collision probability of ObjectId vs UUID in a large distributed system
  20. Changing MongoDB data store directory
  21. Read-only file system when attempting mkdir /data/db on Mac [closed]
  22. mongodb move documents from one collection to another collection
  23. How does the order of compound indexes matter in MongoDB performance-wise?
  24. Multiply field by value in Mongodb
  25. How does MongoDB order their docs in one collection? [duplicate]
  26. count array occurrences across all documents with mongo
  27. How to stop mongo DB in one command
  28. MongoDB on Ubuntu won’t start as a service, nothing in the log
  29. Mongodb concat int and string
  30. Aggregation with update in mongoDB

Leave a Comment