Poor performance adding records

Question

Hi,

We recently deployed an Azure Database for MySQL but have encountered issues related to performance. Specifically, very slow processing of adding new records in a couple of scenarios:

• Microsoft Power Apps
• MySQL Workbench

In each of these situations, if we are to add any number of rows (tested with as few as 1 and as many as 200) it takes nearly two seconds per record to be inserted. In Workbench, this was being added directly from a CSV file.

Initially thinking it was a simple problem just with resource utilization, I've double checked that the server itself is not anywhere near maxing resource capacity. I've tried ramping up the number of vCores with no positive impact on performance either.

Any thoughts would be appreciated.

Answer 1

Hi @kevins , welcome to Microsoft QnA forum and sorry for the trouble you are facing.

Could you please tell me if this was something which was working fine before and this performance issue is something new on the same server?

Meanwhile it looks like this is more or less related to to proximity of MySQL server from the location we are trying to access. I tried by creating multiple Azure MySQL servers and the insertion time varied from 0.078 second to 0.250 second depending upon the location of server. I am basically trying to just do an insert into a table with 9 columns.

If possible, could you just try it by creating a server near to your access location and check the behavior? I am also assuming the network connectivity is fine as well.