We have built a power apps on mobile with SQL Connector .
1. Deployment on Android Mobile
2. Data Connector : SQL Connector
3. Number of Screens : 10 Screens
We have two tenants one for test and another for Production.
While it works well in test , in production it is struggling in performance .
It is taking 25 seconds per db call.
The number of records that we are accessing is same in both test and production
We are using android with 4 GB RAM . Any recommendations
Any help or pointers would help us
Did you try the monitoring tool? If so, what did it tell you?
If you didn't, here's a blog post about it:
Thanks for the response @FabianAckeret ,
We did check the monitor .
SQL server database is on premise on a physical server .
One observation from monitor is :
Every database call whether clearcollect or Lookup is taking 25 seconds irrespective of number of records in the table . Master tables which have just 10 records as well as transaction tables having close to 500 records take 25 seconds each. This is in production environments. We are guessing it is not the table per se but something in between which is causing it . Any pointers would be a great help as operations have stopped
In another environment with a VM hosted on azure cloud( test environment) for the same app, it takes 7 seconds to 9 seconds for all the tables .
I'm afraid I am not the best person to help you on this one. Seems like its local, though.
Did you try to install the gateway on a server/computer outside of your network (for testing purposes only)? Perhaps the firewall or anything else is causing it. Testing it outside of your network removes one possible cause.
I have an update .
Today we created a Azure VM with hosted SQL server and installed Gateway also in the same VM
App is fast .
Is it a good practice to have gateway and SQL Server on the same system ? just wondering what could be the solution
Generally yes, the less distance to the server, the faster. However, I think you could have also optimized your network-environment to get close to the mentioned 7-9 seconds. 25 seconds is quite a lot and I wouldn't consider it as "normal". Perhaps its worth troubleshooting your network, if you don't want to stay on Azure machines.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.