'MongoDB schema pattern Performance
i am not sure about which NoSQL MongoDB schema i should choose. let us say i have collection of patients and collection of doctors. each patient may subscribe for some doctors. should i store doctors ids inside patients collection or the opposite which is storing patients ids inside doctors collection, or both? basically i am asking about performance issue specially about the read. 1- doctor can see all info about their patients 2- patients can also see all info about their doctors
i have tried storing doctors ids inside patients collection because it is highly unlikely for a patient to subscribe for lot of doctors.
but the problem is that i think doctors will have some slowness because the system will try to filter doctor's id in every patient document, and precisely its array of ids in each patient document.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|