Hey guys! What are the benefits of adding Data Pro...
# prisma-data-platformv
Victor
01/19/2022, 4:05 PMHey guys! What are the benefits of adding Data Proxy if you use PlanetScale? They seem to cover connection pooling as well?
a
Alberto Perdomo
01/19/2022, 4:19 PM
Hey Victor, I answered this recently in this channel. I hope this helps.
https://prisma.slack.com/archives/C02EAHBAG93/p1641990590010900?thread_ts=1641979165.010200&cid=C02EAHBAG93
v
Victor
01/19/2022, 4:23 PMThanks @Alberto Perdomo. I'm running my application in a serverless environment (Vercel). But as you mention in your previous answer - PlanetScale supports a quite high number of database connections, I'm wondering if I really need PDP?
Victor
01/19/2022, 4:24 PMI do appreciate that "Connection pooling" is only one feature of many in the Database Platform you are building however, and I might use it for those reasons. But I'm trying to understand if it's really needed if "connection pooling" is the only thing I need atm (when using PlanetScale as well).
a
Alberto Perdomo
01/19/2022, 5:12 PM
Probably not, if you are ok with the number of connections provided by the DB plan you are using. If that is enough or not will probably depend on your workloads. Probably worth trying out. In most cases my guess is that the number of supported connections is enough.
👍 1
v
Victor
01/19/2022, 6:13 PMThanks @Alberto Perdomo
Victor
01/20/2022, 9:10 AM@Alberto Perdomo just FYI - I noticed that the API got a bit faster after removing the prisma data proxy, which makes sense. But it made me curious to understand how much "slower" a request will be if you use the proxy?
Victor
01/20/2022, 9:10 AMI guess it'd be more or less the latency between proxy and the database itself?
a
Alberto Perdomo
01/20/2022, 8:44 PM
What kind of difference in latency are we talking about?
In general, there are more moving parts, but there are a number of factors that come into play:
• base latency - is the DP in the same region as your DB? it should be, ideally
• cold starts - the proxy keeps a connection pool while hitting the DB directly from Lambdas might lead to frequent cold starts
I don’t have data right now that I can share about additional latency. I would expect some requests to be faster directly (fewer hops, warm DB connection) and some to be slower (cold start, need to open a new DB connection).
It will also depend on the DB that you are using and how expensive it is to create a new DB connection there. AFAIK, it’s more expensive on PG than MySQL.
3 Views