Managing Azure SQL Connections in Power Apps

Question

I've built a fairly robust Power Apps Canvas app that has been concurrently deployed on six to ten iPads (depending on time of day). The primary data connection is to an Azure SQL Server (currently set to the S3/100 DTU level). The app doesn't push a lot of data volume but the transactions to the server can be frequent (About 50 parameterized queries in a minute, per device at peak usage).

Performance-wise, sometimes the PowerApp is very fast; less than a second. Sometimes, if the device has been dormant for a while it can take up to ten seconds to reestablish a connection to the database. I was curious if there are any best practices for fine tuning this performance. I've tried managing my SSMS connections, closing them immediately after usage. Is there a way I can manipulate the query timeout, connection timeout, etc; either at the Power App level, the Azure SQL Server level, or in the Azure dashboard for the server or database?

Answer 1

To my knowledge PowerApps are not supported on Microsoft QA. You may get a better support on this forum designated for PowerApps.