Background :
i have try vultr MySQL Server once ( west / east coast server ), my location = Malaysia.
I found that, there is a “Noticible Different” when i use west/east coast server as the Database for my bubbler site ( SQL Connector )
I did try ping both the server from my location, ( not bit different, around 100ms ping ), which might notice if online gaming, but not for my Site.
My Question.
Did the 3rd Party Database Server loc has to be as close to Bubble Actual Server location for best performance??
So the data is sent to bubble server 1st then to me as viewer?
Most likely and it depends on your situation but yes you may want to choose a server close to bubbles servers. Bubble proxies a lot, but not all, of your apps api traffic both front and backend(of course). You can make GET calls from client side to xano direct during which only a record of the api call is transmitted to bubble while the call occurs client side. But you can’t have any private info like an api key you don’t want exposed client side.
Worry not, you have much more leverage on performance gains through clever application, datamodel and architecture design than distance between Bubble’s server and your database.
Come back to this point once you tried every other possible improvements.
