This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
My learning: Thumb rule checklist for app performance.
While I did have an awareness on inefficiency of certain functions like SELECT() , in the post referred above, @Steve and @praveen have excellently elaborated the concept. I will have that post as reference post on app performance.
My thumb rule checklist learning from this post on performance.
Any single factor may or may not contribute to performance degradation. Performance degradation may be combination of several factors mentioned below
Use of multirow expressions- SELECT(), FILTER(), LOOKUP(),MAXROW(),MINROW() in virtual columns or in format rule expressions.Inefficient format rules impact display/rendering time
More tables, more rows of data in the app. A) N tables, assume N/3 seconds of baseline latency B) Find largest table in terms of cells (rows * columns) and add 1 second for every 5000 cells
Filtering conditions -
Equality (=), IN(), and AND() of these are efficient. Inequality(<>) and OR() functions are inefficient
Certain inherent latency is introduced by cloud provider as well. This latency is not necessarily related to data size.
REF_ROWS VCs auto created by the app editor are not inefficient.
In general, multi level SELECT() statements (A SELECT() in another SELECT() ) are a no-no.
I’ve learned that AppSheet blog “Feature Friday” is a very good reference for me, in addition to the “What’s New” and “Tips & Trick” Section of this Community.
LinkedIn
Twitter
