Solved: Improve the performance of expressions - Page 2

daniel_sanchez · 08-09-2022 02:07 PM

I have an app to control the entry of materials in my warehouse, so among the things he does, is control the status of each pallet, for example, if the pallet is in transit to my store, or the pallet is in the store, or if the pallet was already collected, the formula counts how many pallets are found in each status.

The problem is that I have a lot the virtual columns with many types of formulas and some impact on the performance. for example this expression there is a way to change to another?

i already create the reference between a tables

dbaum

There may be opportunities for simplification using techniques like Build list dereferences - AppSheet Help.

One detail you can address easily is to remove the superfluous LIST wrapping function. The SELECT function itself returns a list and since you're not combining that result with another list, there's no need to embed it within the LIST function.

View solution in original post