mongodb-indexes - w3toppers.com

Mongo unique index case insensitive

Prior of MongoDB version 3.4 we were unable to create index with case insensitive. In version 3.4 has collation option that allows users to specify language-specific rules for string comparison, such as rules for lettercase and accent marks. The collation option has the following syntax: collation: { locale: <string>, caseLevel: <boolean>, caseFirst: <string>, strength: <int>, … Read more

Overflow sort stage buffered data usage exceeds internal limit

You’re running into the 32MB limit on an in-memory sort: https://docs.mongodb.com/manual/reference/limits/#Sort-Operations Add an index to the sort field. That allows MongoDB to stream documents to you in sorted order, rather than attempting to load them all into memory on the server and sort them in memory before sending them to the client.