Optimize sync times

[Pethipojquis56]

was wondering how i can reduce these times, what is gstrtivestorageproviderr and xlxspreadsheet data

and why are they potentially taking so long 

[Fernando_Lopez1]

I recommend to migrate to google sheets

[Swoopy]

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.