Hello,
Will there be a significant performance difference between collections with significantly different number of documents? Let’s say we have Scenario 1 that has 10 collections with each one containing 10 millions documents versus Scenario 2: 1 collection with 100 million documents.
The document sizes are equal in all cases with each one being 1 MB each on average.
My educated guess based on RDBMS technology is that Scenario 2, will be slower since the indexes on the single collection will have B-tree indexes that will have many more levels which will result in additional reads and contention on the index. This is the case with RDBMS tables, need to confirm that this will result in the same issue in Mongo collections.
Thank you