Lab 4.2 Aggregation Performance

MongoDB University M201: MongoDB Performance
#1

Hi All,

While I successfully managed to replicate the error in console, my aggregation worked fine in compass without any index other than default _id. Is the memory constraint for compass different than 100MB limit?

{
“ok”: 0,
“errmsg”: “Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.”,
“code”: 16819,
“codeName”: “Location16819”
}

I

#2

It’s probably possible that Compass has the allowDiskUse option set to true by default which bypasses the 100MB pipeline stage limit.
Are you positive that this is for the same dataset? Perhaps you can double check their counts.