I have multiple 100 M documents using Nested Document for joining. It is the fastest way for joining in a single replica. By adding more replicas (2 or 3), the performance is slow down significantly. (about 100x times). Does anyone have same experience?
Jae