Hey everyone. Nice to meet y'all. I have a questio...
# orm-helpk
Kenny Tran
09/15/2022, 12:24 PMHey everyone. Nice to meet y'all. I have a question regarding Prisma's $transaction API. I'm currently using it to run two queries sequentially but how many more queries can i add before it becomes a problem. I'm quite new to Prisma 🙂
✅ 1
j
Jarupong
09/15/2022, 12:28 PMHi Kenny Could you give an sample code that cause the problem?
k
Kenny Tran
09/15/2022, 12:34 PMThere's no problem yet, I'm just thinking ahead. Currently I have two sequential queries like so -
Copy code
const [queryOne, queryTwo] = await prisma.$transaction([...])
//what would happen if -
const [queryOne, queryTwo, ... , queryN] = await prisma.$transaction([...])j
Jarupong
09/15/2022, 12:37 PMAs I test on my Production with multiple queries it works fine
k
Kenny Tran
09/15/2022, 12:38 PMHow many queries are you using?
j
Jarupong
09/15/2022, 12:39 PMIt depends on user sending ids
Jarupong
09/15/2022, 12:39 PMIt's around 50 ~ 100 queries
Jarupong
09/15/2022, 12:39 PMIf you concern about timeout issue or idle time
I suggest you to use interactive transaction API instead
https://www.prisma.io/docs/concepts/components/prisma-client/transactions#interactive-transactions-in-preview
Jarupong
09/15/2022, 12:40 PMyou can custom isolation level, idle connection time, and timeout with mili second number specifically
k
Kenny Tran
09/15/2022, 12:41 PMOkay great thanks
j
Jarupong
09/15/2022, 12:42 PM Copy code
await prisma.$transaction(async (tx)=>{
// calling your queries here with tx
}, { isolationLevel: 'ReadUncommitted', maxWait: 10000, timeout: 30000 })Jarupong
09/15/2022, 12:43 PMPlease use transaction with caution as Prisma team mentioned
3 Views