Data consistency in Mongodb good practice

Working with Data
,
3

Hello,

I have two options now,

  1. Store _id of the Employee in Lead, the downside is if I’m fetching 1000 records, 1000 lookups have to be performed.

  2. Embed employee details such as ‘name’ and ‘_id’ on the lead document. The downside is, if the employee name is updated, all lead documents with the employee details have to be updated.

On the second approach, employee names will not be updated often, but when it does, it’s gonna affect a larger chunk of records. My only concern is that, is it okay to execute an update operation even if it is going to affect millions of records, wont there be any performance issue while updating large volume of records.