This is an FYI. I'm working on my first app. I'm using an On-Premise SQL Server. I've been for ways to improve performance. I'm using collections and optimizing views. I'm using SQL Profiler to check and measure performance. I found one thing I wasn't expecting. The Details and Edit screens use Lookups for the Item property. When the screens load it executes the Lookup even though no Gallery item property is selected. I have 4 main tables so 8 useless queries. I added this to avoid the query.
If(!IsBlank(varClientID),LookUp('[dbo].[ClientVDT]',ClientID = varClientID))
It only saved me 300ms so not earth shattering.
Solved! Go to Solution.
I actually read that article in detail before starting my efforts. He didn't cover the detail I discovered so I thought I would post it.
Thanks for the feedbacks.
Actually Staff Mehdi Slaoui Andaloussi posted a blog talking about this:
Performance considerations with PowerApps
Which shares the query detail when Data (or saying the App) is loading.
Regards,
Michael
I actually read that article in detail before starting my efforts. He didn't cover the detail I discovered so I thought I would post it.
User | Count |
---|---|
246 | |
105 | |
82 | |
50 | |
43 |