Hi!
Does anyone have experience with running large transactions (200k updates) on RDS instances?
Dumping the DB and running the prisma transaction locally finishes in around 2 minutes, while doing the same thing with RDS haven't finished yet (it would likely take hours). We don't get any errors it's just that it takes super long.
A bit more context:
The transaction is basically running a migration, it's quite complex so it's written in TS+prisma instead of raw sql.
An alternative solution seems like that we stop the application for a while, dump the prod DB, run the migration locally then restore it to production. We can work with this, it's just that I'm curious about what's up with doing the whole thing over the wire, what could be the issue.