Performance problem when using composite index of Azure Cosmos DB for MongoDB

Question

I'm using Azure Cosmos DB's for MongoDB, but I'm trying to put a composite index in mongoose because I can't use the sort function without an index, but it's expected that the performance is degraded due to frequent updates at scale. Is there any way to recommend it?

Thank you in advance

Answer 1

Hi @@디엔소프트 DNSOFT , thanks for your patience. Yes you are right that if we want to apply the sorting we need to index the fields/properties appropriately. However as per the verbatim from the article, there is no performance issue that we observe while the updates happen in the background.

Please let us know if this helps or else we can discuss further on the same.

----------

If answer helps, please 'Accept Answer' as this could help other community members looking for similar queries.