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 |
|---|---|---|---|
| Mobile Groupchat Database Design | 0 | 189 | Jul 2024 |
| I merged all my collections into one and the CPU got super high | 1 | 174 | Sep 2024 |
| Help me understand mongo’s index caching | 4 | 274 | Oct 2024 |
| It is good practice to create a separate collection for each dataset in MongoDB? | 9 | 123 | Feb 28 |
| Converting a embedded documents (nested array) first elements property into different data type? | 0 | 10 | Mar 19 |