juxtaposition-ui icon indicating copy to clipboard operation
juxtaposition-ui copied to clipboard

[Enhancement]: Use indexes for Mongo collections

Open jonbarrow opened this issue 1 year ago • 0 comments

Checked Existing

  • [X] I have checked the repository for duplicate issues.

What enhancement would you like to see?

When a collection has no indexes, Mongo will perform a full COLLSCAN on the collection, scanning all documents to perform the query. This can very easily eat all available resources when working with

  • Large databases
  • Low performance queries
  • Complex aggregations

When there are many documents, and many scans of those documents, Mongo can easily max out CPU usage and remain there. When working with very large documents (such as those which contain files), this can also easily max out memory usage.

Any other details to share? (OPTIONAL)

No response

jonbarrow avatar May 31 '24 15:05 jonbarrow