Remote MySql database server for local development using Xampp is slow

[kalle@makewebo]

Hi!

We are trying to use the same database for our local development in our team. We have managed to connect to the database but it's extremly slow at fetching the data. We have trouble finding why, and perhaps someone here can shed some light.

So we are using Xampp and have setup a Mysql server on Azure (Basic setting, 2 virtual cores, 10GB).

Testing using the local db from Xampp our start page loads within 3-5 seconds (No caching or performance settings turned on)

Loading the same page using our remote mysql server it loads within 30-40 seconds.

One thing that could obviously be the bottleneck is our MySql Server just being to slow. But fetching data using Mysql Workbench is no problem in speed. We are only three members in our team, so the server should be able to handle the workload.

It feels like there is some setting in either Xampp or Prestashop that just doesn't play with our remote server.

Does anyone have any ideas what we can try to speed things up? Or should we just give up on the idea to be able to use the same database (or any other way to do it?)

The reason we want to share database is so we don't have to setup all configurations for shops/modules/whatever for every user every time we makes changes/improvements.

 

Best Regards