Skip to main content
3 events
when toggle format what by license comment
Apr 4, 2017 at 15:18 answer added JJussi timeline score: 0
Mar 7, 2017 at 22:22 comment added Antonios Each shard will have to maintain all indexes. With sharding you will achieve to maintain smaller "local" indexes but each shard must have all indexes. Assuming you searching for price:{$gt:10}. Most probably this query will hit all three shards. If you are missing the {price:1} index on one shard the query will perform a full collection scan which will slow down your database. If I understand your question you want to scale writes. The best way is a shard key like {_id:hashed} or any other field that can achieve write scale and a minimal set of indexes - consider partial indexes as well.
Mar 1, 2017 at 15:08 history asked Adé CC BY-SA 3.0