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.