I am new to Spring and MongoDB. Trying to identify that when I had to process records from more than one collection, is it better option to do a lookup or go for writing code in spring or go for lookup?
1 Answers
It cannot be explicit to decide due to the following reasons.
- Data size
- Number of collections which will be part of lookup
- Index usage
- Query efficiency.
It's better to evaluate both the options and decide. This is a good article to understand schema design
Related