Slow Prisma query speeds | Railway | Page 1

ornate palm Mar 3, 2023, 10:33 AM

#

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?

main ospreyBOT Mar 3, 2023, 10:33 AM

#

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.

#

No project ID was provided. Closing thread.

ornate palm Mar 3, 2023, 11:11 AM

#

d5eccacc-fc95-4f68-90bc-f8f04565d014

sweet wadi Mar 3, 2023, 5:11 PM

#

wheres your db located

ornate palm Mar 5, 2023, 1:50 PM

#

sweet wadi wheres your db located

hey! sorry just saw this message. my database is located AWS ap-south-1 (mumbai).

sweet wadi Mar 5, 2023, 1:51 PM

#

that will be why

#

railways infra is hosted in the usa

ornate palm Mar 5, 2023, 6:01 PM

#

sweet wadi that will be why

is railway expanding to other locations in anytime soon in the near future?

sweet wadi Mar 5, 2023, 6:02 PM

#

Ye hopefully

ornate palm Mar 5, 2023, 6:03 PM

#

gotcha ty!

brave grail Mar 5, 2023, 9:51 PM

#

ornate palm is railway expanding to other locations in anytime soon in the near future?

Expansion to other regions is expected to be completed this quarter

#

may be a bit longer, but it’s in progress

#Slow Prisma query speeds