David•2y ago

How would batching result in a single database query?

On the httpBatchStreamLink docs it says that multiple query calls could result in a single database query. How would that work? Should you expect the passed input to possibly be an array to allow for this?

After that, you can make use of batching by setting all your procedures in a Promise.all. The code below will produce exactly one HTTP request and on the server exactly one database query:

After that, you can make use of batching by setting all your procedures in a Promise.all. The code below will produce exactly one HTTP request and on the server exactly one database query:

4 Replies

Alex / KATT 🐱•2y ago

if you use a dataloader for fetching stuff

Alex / KATT 🐱•2y ago

https://github.com/graphql/dataloader

GitHub

GitHub - graphql/dataloader: DataLoader is a generic utility to be ...

DataLoader is a generic utility to be used as part of your application's data fetching layer to provide a consistent API over various backends and reduce requests to those backends via batc...

Alex / KATT 🐱•2y ago

prisma does this automatically for findUnique https://www.prisma.io/docs/guides/performance-and-optimization/query-optimization-performance#solving-the-n1-problem

Prisma

Query optimization

How Prisma optimizes queries under the hood

DavidOP•2y ago

Thank you! Is there some example code for this using trpc?

How would batching result in a single database query?

Did you find this page helpful?