See the logs in the screenshots

Hello,

I notice you have your databases on GCP and your other services on Metal, please move all services to the same region and let me know if the performance improves.

Best,

Brody

I switched that, and it looks like it works faster now. However the database seems to work sequentially. do i need to add more pools in prisma ?

The performance is slightly worse than on my mac though.
average response time is 1.5 times more than locally.

Even though i've set it up correctly now.

Hello,

The databases aren't sequential, we have many users using them at many thousands of TPS, the bottleneck here would have to come from your code.

I'm glad the performance has improved, but unfortunately, we won't be able to offer coding assistance or advice here, perhaps forums such as StackOverflow could help you further?

Best,
Brody

So it is possible for me to horizontally scale my application and make f.e. 3 prisma instances reference the same Database, where all have different functionalities ( Read and write f.e. ) ?

You can horizontally scale -

https://docs.railway.com/guides/optimize-performance#configure-horizontal-scaling

But you would need to handle the database logic in code.