cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Re: Azure SQL Server database calls takes minutes instead of seconds

Slow SQL calls again today...

dboulet
Level: Powered On

Re: Azure SQL Server database calls takes minutes instead of seconds

I highly recommend using Collections instead of direct queries to SQL. That has fixed all of my issues.

 

Hope this helps!

lero
Level: Powered On

Re: Azure SQL Server database calls takes minutes instead of seconds

The issue is not related with queries and Collections. It's the internal gateway between PowerApps and Azure SQL that slow things down. I only use Collections and my queries used to load them are optimized.

 

Anyway... I hadn't any report from users on my side about slowness. I think the PowerApps/Azure teams figured it out.

Anonymous
Not applicable

Re: Azure SQL Server database calls takes minutes instead of seconds

Thanks, @lero! I will definitely check it out!

nbarsley1
Level: Powered On

Re: Azure SQL Server database calls takes minutes instead of seconds

Hey Lero, 

What do you mean by your queries are optimized and you only use collections? 

 

Do you mean onstart -> load all necessary data to collections? 

 

Thanks!

lero
Level: Powered On

Re: Azure SQL Server database calls takes minutes instead of seconds

I mean I apply filters on columns with proper indexing and never load a lot of rows. On average my queries returns no more than 50 rows.

 

To load everything onstart causes the app to spend a long time starting. A best practice is to load ondemand according to screen usage or using the timer component.

 

Most of my loading time is spent on onvisible events and besides that I try not to load a Collection twice unless necessary.

 

 

ChristophM
Level: Powered On

Re: Azure SQL Server database calls takes minutes instead of seconds

Same problems here. It´s also a frustrating experience to patch a row to the Azure database. Sometimes it needs only 0.2 seconds and then it needs 28 seconds to write a simple row to the Azure database. 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,831)