was wondering how i can reduce these times, what is gstrtivestorageproviderr and xlxspreadsheet data
and why are they potentially taking so long
I recommend to migrate to google sheets
My few tips to reduce sync duration.
-Avoid using aggregated/list expressions like SELECT, FILTER, SUM, MAX, MIN etc. inside your apps.
-Minimize number of columns that can be searched, especially the ref type.
-Minimize number of format rules & actions.
-Reuse expressions & reduce duplicated expressions when possible. For example if you are about to build an expression(codes) for a slice but some codes are already used in virtual columns(VC), you just refer to the VC. Do not copy the codes.
-If you’re not using system generated actions, set them to ‘Do not display’ and delete expression in its ‘Only if this cond…’ automatically created by AppSheet.
-Build expressions wisely, for example
FIND(…) > 0 would be faster than CONTAINS(…) , FIND(…) = 0 would be faster than NOT(CONTAINS((…))
OR(cond1, cond2, cond3, cond4) would be slower than
IFS(
cond1(higest possible),
TRUE,
cond2,
TRUE,
cond3,
TRUE,
TRUE,
cond4(lowest possible)
)
However if you have 30,000+ rows, the sync would always noticeably take longer. When you are encountering huge data, everything counts.
3 Likes