Is there a way to optimize this approach?

Question

Node.js

Good day.

I have a user collection and related collections like emailConfirmation which refers to user.

I mean emailConfirmationModel:

userId: {
    type: Schema.Types.ObjectId,
    ref: 'User',
  },

When getting user data, I need to somehow get information about both the user and the emailConfirmation collection.

At the moment, these are 2 different queries to the database.

const user = await User.findOne...
const userConfirmationInfo = await emailConfirmation.findOne...

Next I tie them together

const data = { ...user,  ...userConfirmationInfo };

But I am almost certain that this is a crutch approach.

Can you please tell me how to optimize the solution of this problem?

Answer 1

https://mongoosejs.com/docs/populate.html
Works like your code under the hood, i.e. sends multiple queries to the database