TypeScript Database Optimization

Optimize: $ARGUMENTS

1. N+1 Query Elimination

The classic trap: fetching a list, then querying per item in a loop.

// N+1: one query for the list, one per item
const orders = await db.order.findMany();
for (const order of orders) {
  order.customer = await db.customer.findUnique({ where: { id: order.customerId } });
}