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.
What do you mean by your queries are optimized and you only use collections?
Do you mean onstart -> load all necessary data to collections?
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.
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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications