My app has 30 tables. The parent table is RECORD, the remaining tables refer to the RECORD table. The record table has about 35 columns and the SELECT function is rarely used in the Formula. However, when saving data, it takes about 2 minutes. I don’t know what’s the cause?
Here is my performance image
At the top of your log, you have the “Edit row” entry. Click on the “binoculars” icon to drill into the entry and try to determine what function(s) are taking the most time. This may identify areas where you can improve the logic and reduce performance time.
One thing NOT shown in these logs are sheet side formulas. If you are using a sheet and it has formulas that are triggered when data is posted, AppSheet will wait for the formulas to finish before pulling back in the updated data. If you have cascading formulas, these can cause a significant delay in Adds and Edits.
1 Like