How to deal with error output " MongoError: Sort exceeded memory limit of 104857600"

A query that is running fine with a limit stage throws an error without it. When running the query from mongo compass without a limit I dont get an error either.

Is this a known issue with moralis servers, if so - how to overcome this?

MongoError: Sort exceeded memory limit of 104857600

what you mean with limit storage?

what kind of query you make when you get that error?

I have an aggregation that throws the error described above and another output hints its cause of a sorting stage. When I limit the aggregation results to 100 for example, the error is gone.

MongoError: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.

I don’t know now how to fix this