P
Prisma3mo ago
David

Set max execution timeout

Hi, is there a way with Prisma to set a max query execution timeout? I know there isn't really a built-in way, but was hoping there is a workaround available such as running a raw query directly after client initialization?
5 Replies
Nurul
Nurul3mo ago
Hey @David 👋 Are you perhaps looking for socket_timeout? https://www.prisma.io/docs/orm/overview/databases/postgresql#arguments Assuming you use PostgreSQL
PostgreSQL database connector | Prisma Documentation
This page explains how Prisma can connect to a PostgreSQL database using the PostgreSQL database connector.
David
David3mo ago
We use MySQL unfortunately. I should have mentioned
Nurul
Nurul3mo ago
socket_timeout exists for MySQL as well, Could you try it? https://www.prisma.io/docs/orm/overview/databases/mysql#arguments
MySQL database connector | Prisma Documentation
This page explains how Prisma can connect to a MySQL or MariaDB database using the MySQL database connector.
David
David3mo ago
Ah very cool, will try, thanks!
Nurul
Nurul3mo ago
No worries! 😄