Faster code.
Lower costs.
Zero effort.

const getUsers = async () => {
  // Fetching all users from database
  const allUsers = await db.collection('users').find({}).toArray();
  
  // Filtering in application code
  return allUsers.filter(user => 
    user.isActive && 
    user.subscription.status === 'paid'
  );
}

const getUsers = async () => {
  // Using database indexes and filtering at db level
  return await db.collection('users')
    .find({ 
      isActive: true,
      'subscription.status': 'paid' 
    })
    .toArray();
  
  // Added compound index on isActive + subscription.status
}