Multiple lookup stages vs multiple separated find queries

[turivishal (Vishal Turi)]

Okay,

@Nohelia_Rincon

• Request multiple queries to DB, one to populate the department, and another to get the specific setting per department (considering this will require merging the information in execution time afterward)

If the total number of documents in the Department and Settings is less or the size is less then you can fetch them all together through a separate query and merge it with the respective Recordings and Calls. This is better than the first option (nested lookup) if you are fetching large amounts of documents from Recordings and Calls.