Connection Pooling
Hi Neon Team, I've deployed my applicaiton using Neon as the DB, Prisma as the ORM and it's built on Next JS/hosted on Vercel. I'd like to activate Pooling to improve performance, what do I need to do in regard to Vercel and Prisma to acheive this properly?
6 Replies
rare-sapphire•13mo ago
Make sure that when you grab the connection URL from the Neon Console, you have the “Pooled” checkbox checked.
optimistic-goldOP•12mo ago
Thanks @David Gomes, so I simply need to check connection pooling, then replace the connection URL in Environment Variables on the Vercel Deployment ?
rare-sapphire•12mo ago
Yup!
optimistic-goldOP•12mo ago
Thanks @David Gomes, and how can i increase my connection limit but not turn on connection pooling?
rare-sapphire•12mo ago
That I personally don’t know. Why can’t you turn on connection pooling?
vicious-gold•12mo ago
@Kgram
To do so, read more on https://neon.tech/docs/manage/endpoints#how-to-size-your-compute. TLDR: increase your min CU.
Neon
Manage computes - Neon Docs
A primary read write compute is created for your project's default branch. To connect to a database that resides in a branch, you must connect via a compute associated with the branch. The following d...