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
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.
We use MySQL unfortunately. I should have mentioned
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.
Ah very cool, will try, thanks!
No worries! 😄