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.
