Paging with count - Performance $facet vs. simple query

[Mile_Stoilovski]

similar topic:

For a big collection of documents, it is faster to execute 2 queries or use aggregations?

For a big collection of documents, it is faster to execute 2 queries (the paginated results and the total count) or it is faster to use aggregations? Example aggregation query [ { $match: conditions }, { $sort: { createdAt: -1 } }, { $group: { _id: null, count: { $sum: 1 }, results: { $push: "$$CURRENT" }, }, }, { $project: { count: 1, results: { $slice: ["$results"…