Slow Prisma query speeds

Hey! I'm using Prisma as my ORM. Recently Prisma was taking my longer than usual on Railway (it was working fine on local development environment, with the exact same database). I ran a test to compare the query speed and turns out that it took ~800ms to complete a simple createMany Prisma query. Whereas, it 100ms on local development environment. The possible explanation for such behavior is network latency, but is there any way to reduce the time?
11 Replies
Percy
Percy2y ago
Please provide your project ID or reply with N/A. Thread will automatically be closed if no reply is received within 10 minutes. You can copy your project's id by pressing Ctrl/Cmd + K -> Copy Project ID.
Percy
Percy2y ago
No project ID was provided. Closing thread.
Mukesh
MukeshOP2y ago
d5eccacc-fc95-4f68-90bc-f8f04565d014
Finn
Finn2y ago
wheres your db located
Mukesh
MukeshOP2y ago
hey! sorry just saw this message. my database is located AWS ap-south-1 (mumbai).
Finn
Finn2y ago
that will be why railways infra is hosted in the usa
Mukesh
MukeshOP2y ago
is railway expanding to other locations in anytime soon in the near future?
Finn
Finn2y ago
Ye hopefully
Mukesh
MukeshOP2y ago
gotcha ty!
Adam
Adam2y ago
Expansion to other regions is expected to be completed this quarter may be a bit longer, but it’s in progress
Mukesh
MukeshOP2y ago
awesome ty!
Want results from more Discord servers?
Add your server