I have a prisma setup locally connected to a AWS RDS. I have 50,000 records to insert, why is my speed so slow? I did this locally with local database, it was much quicker.
h
Huy Nguyen
05/22/2019, 4:39 AM
you might wanna share how to set it up locally?
Huy Nguyen
05/22/2019, 4:40 AM
I have a LightSail Database and I am trying to set it up with Prisma, but I got unreachable status without any clear direction or info about the bug
b
bkstorm
05/22/2019, 7:23 AM
I think there are many reasons that make your query slow: indexes, triggers, .... Because your query is very fast on local, so I just assume the problem is not the sql query, it should be optimized by Prisma, so we don't care about it.
j
Jscott388
05/22/2019, 12:39 PM
I’m doing mutations. Have it setup Async. Locally with docker and postgres runs quickly. When running docker locally connected to aws rds it slow.