One of the collection has 2516269 document where one of the field is state with possible value of “OPEN” ,”EXCLUDED” . When I try to retrieve document with state:”OPEN” with match operator it is taking 3.3 sec … I am trying to reduce to 1 sec … can we do that …
Skip to main content
Yes by using a proper index.
New & Unread Topics
| Topic | Replies | Views | Activity |
|---|---|---|---|
| How to Efficiently Rename a Field Across 1 Million MongoDB Documents? | 1 | 693 | Jul 2024 |
| MongoDB.Driver.MongoCommandException: Command insert failed: WriteConflict. | 0 | 199 | Aug 2024 |
| Q. Write Performance | 1 | 53 | Sep 2024 |
| Problem filtering an array, cond if field is null does not work | 2 | 88 | Oct 2024 |
| try to implement forward filling in mongo db | 1 | 28 | Oct 2024 |