Free mini course
Your One List Query Is Really 201 Queries
The endpoint reads like a single call. findMany, return the rows, done. Then every row reaches for its author and the ORM quietly fires one more query for each one. Two hundred round trips in series, eight milliseconds apart, and not one of them is slow on its own.
This Short draws the fan out moving: the list query returns two hundred rows fast, the lazy relation loads row by row, the round trips stack up, and a 1.6 second response arrives with no single slow query to blame. Then the fix: ask
Watch on YouTubeThe endpoint reads like a single call. findMany, return the rows, done. Then every row reaches for its author and the ORM quietly fires one more query for each one. Two hundred round trips in series, eight milliseconds apart, and not one of them is slow on its own.
This Short draws the fan out moving: the list query returns two hundred rows fast, the lazy relation loads row by row, the round trips stack up, and a 1.6 second response arrives with no single slow query to blame. Then the fix: ask
Frequently asked questions
What is Your One List Query Is Really 201 Queries about?
The endpoint reads like a single call. findMany, return the rows, done.
Which topics does this mini course relate to?
Backend Development, Prisma ORM.