R
Railway12mo ago
ocosta

MySQL RailWay slow queries

Hi, I have a simple desktop app with PyQt5, a Python library to make GUI, that connects to a MySQL railway database. However, the queries seem slow to me, taking around 5 seconds. How can I improve this? I'm using a hobby plan.
Solution:
moved to dms, will update this thread later edit: a database in us-east wasn’t much faster, user will use planetscale...
Jump to solution
14 Replies
Percy
Percy12mo ago
Project ID: N/A
Brody
Brody12mo ago
are you perhaps located far away from railways default region of us-west1?
ocosta
ocosta12mo ago
yeah, i'm in Brazil i think this possibility this is it?
Brody
Brody12mo ago
for sure that could be it regions are available on the pro plan, and I would say the closest region available would be us-east
ocosta
ocosta12mo ago
Even so, it shouldn't improve much, right? Because of the distance.
Brody
Brody12mo ago
i honestly couldn't tell you, i could spin up a test database in us-east for you to test on if you'd like?
ocosta
ocosta12mo ago
I would greatly appreciate it if you could.
Brody
Brody12mo ago
if the times improve, would you be interested in upgrading to pro?
ocosta
ocosta12mo ago
yeah
Brody
Brody12mo ago
okay will dm you the url shortly
ocosta
ocosta12mo ago
okay, thanks a lot
Brody
Brody12mo ago
its going to be a blank db, so you will have to seed it yourself
ocosta
ocosta12mo ago
no problem
Solution
Brody
Brody12mo ago
moved to dms, will update this thread later edit: a database in us-east wasn’t much faster, user will use planetscale
Want results from more Discord servers?
Add your server