do i have to disconnect prisma client

[inland flint]

i have a api route that creates a new PrismaClient() everytime its ran and doesnt disconnect it
do i make it disconnect before returning data?
bit unrelated i know lol but idk where else to ask this

[safe sedge]

Post created!

🔎 This post has been indexed in our web forum and will be seen by search engines so other users can find it outside Discord

🕵️ Your user profile is private by default and won't be visible to users outside Discord, if you want to be visible in the web forum you can add the "Public Profile" role in id:customize

✅ You can mark a message as the answer for your post with Right click -> Apps -> Mark Solution
(if you don't see the option, try refreshing Discord with Ctrl + R)

[old rain]

normaly your ORM (prisma in this case) opens a connection to your database. You should close this connections after you are done with the sql query. Else you may hit the too many clients error and you wont be able to query your database anymore. So make sure you either close them directly manually after you done or automatically via a idle timeout for example

[inland flint]

so when i return data PrismaCleint doesnt automatically close the connection?

Oof

K thanks

[old rain]

it looks like you can directly disconnect it after your query is done. As said: you can either close them manually (https://www.prisma.io/docs/orm/prisma-client/setup-and-configuration/databases-connections/connection-management#disconnect) or automatically by setting up a idle timeout