MongoDB {aggregation $match} vs {find} speed

by

The main purpose of the aggregation framework is to ease the query of a big number of entries and generate a low number of results that hold value to you.

As you have said, you can also use multiple find queries, but remember that you can not create new fields with find queries. On the other hand, the $group stage allows you to define your new fields.

If you would like to achieve the functionality of the aggregation framework, you would most likely have to run an initial find (or chain several ones), pull that information and further manipulate it with a programming language.

The aggregation pipeline might seem to take longer, but at least you know you only have to take into account the performance of one system – MongoDB engine.

Whereas, when it comes to manipulating the data returned from a find query, you would most likely have to further manipulate the data with a programming language, thus increasing the complexity depending on the intricacies of the programming language of choice.

More Related Contents:

  1. Does MongoDB’s $in clause guarantee order
  2. $lookup on ObjectId’s in an array
  3. Mongodb sort inner array
  4. Return only matched sub-document elements within a nested array
  5. Converting string to date in mongodb
  6. Check if every element in array matches condition
  7. MongoDB nested lookup with 3 levels
  8. How to aggregate sum in MongoDB to get a total count?
  9. MongoDB : Aggregation framework : Get last dated document per grouping ID
  10. MongoDB Full and Partial Text Search
  11. Matching ObjectId to String for $graphLookup
  12. Mongodb Join on _id field from String to ObjectId
  13. Rounding to 2 decimal places using MongoDB aggregation framework
  14. What’s the $unwind operator in MongoDB?
  15. Mongodb aggregation lookup with conditions
  16. How to get back the Original document back after aggregation
  17. MongoDB lookup when foreign field is an array of objects
  18. Search on multiple collections in MongoDB
  19. Poor lookup aggregation performance
  20. Remove Duplicates from MongoDB
  21. $skip and $limit in aggregation framework
  22. $unwind an object in aggregation framework
  23. Mongodb Aggregation Framework | Group over multiple values?
  24. Sum in nested document MongoDB
  25. count array occurrences across all documents with mongo
  26. Mongodb concat int and string
  27. Export mongodb aggregation framework result to a new collection
  28. mongodb aggregate query isn’t returning proper sum on using $sum
  29. MongoDB aggregate by field exists
  30. MongoDB aggregate within daily grouping [duplicate]

Leave a Comment