Dear All Experts,
Here I have a 300+GB collection, which I need search documents by a specific date, and most likely around 2800 documents related to that one specified date. I just test this query on standalone Mongod, the response time is more than 2 seconds, which I need it to be less than 1 or even 0.5 seconds. Consequently, I’m considering sharding, is that hashed shard key on date field will fit my requirement?
Good day!
Best regards,
Yuyong