Order of $sort and $limit aggregation

[steevej (Steeve Juneau)]

Note that your sort, skip and limit in

@Aniket_Jha

projectModel.aggregate(pipeline)
  .sort({ updatedAt: -1 })
  .skip(skip)
  .limit(limit)

are done after the whole pipeline is completed.

If you want us to comment on your pipeline, please post your pipeline in the standard pipeline language rather than your own notation like:

@Aniket_Jha

$match(userId) > $sort(updatedAt) > $limit(limit + skip) > $skip (skip) > $lookup(html_collection) > $lookup(records_collection)