I have an Access web App witch creates an Azure sql database. From SharePoint I created an external list to one of the tables. The connection is fine but very, very, slow. About 10 seconds when returning only two records.

This gives me some time out issues in the flow of my program. Is there a way to speed up the connection?

Thanks, Mike

Hi Mike,

It may be due to the network issue, if there are some timeout issue, you can use fiddler to check if most time is spent on the network traffic, then it's the case, you may need to use the high speed network, see if it could help.

If it's not the network issue, please check if Azure sql performance is expected.

https://msdn.microsoft.com/en-us/library/azure/dn369873.aspx#Resource

Thanks

Daniel Yang