How to delete documents by query efficiently in mongo?

by

You can use a query to remove all matching documents

var query = {name: 'John'};
db.collection.remove(query);

Be wary, though, if number of matching documents is high, your database might get less responsive. It is often advised to delete documents in smaller chunks.

Let’s say, you have 100k documents to delete from a collection. It is better to execute 100 queries that delete 1k documents each than 1 query that deletes all 100k documents.

More Related Contents:

  1. Find document with array that contains a specific value
  2. Update field in exact element array in MongoDB
  3. How to change the type of a field?
  4. Mongodb sort inner array
  5. Return only matched sub-document elements within a nested array
  6. MongoDB wildcard in the key of a query
  7. How to create a DB for MongoDB container on start up?
  8. MongoDB field order and document position change after update
  9. MongoDB Full and Partial Text Search
  10. How to enable authentication on MongoDB through Docker?
  11. Mongodb Join on _id field from String to ObjectId
  12. How do I do a “NOT IN” query in Mongo?
  13. How to efficiently perform “distinct” with multiple keys?
  14. Hierarchical queries with Mongo using $graphLookup
  15. Search on multiple collections in MongoDB
  16. Mongo, find through list of ids
  17. Image returned from REST API always displays broken
  18. Difference between “id” and “_id” fields in MongoDB
  19. MongoDB nested array query
  20. Filtering embedded documents in MongoDB
  21. Remove multiple documents from mongo in a single query
  22. Is mongodb running?
  23. Sum in nested document MongoDB
  24. Update embedded object inside array inside array in MongoDB
  25. Map-Reduce performance in MongoDb 2.2, 2.4, and 2.6
  26. Unique IDs with mongodb
  27. Cannot import mongodb
  28. MongoDB count() versus countDocuments()
  29. mongodb : Increasing max connections in mongodb
  30. Create filter aggregation in spring

Leave a Comment