best practices for read-only data for faster syncing?

[Charlie_Wells]

a) Is it better to keep them in a separate workbook (Google sheet) rather than in the same spreadsheet as the data that the user can update?

b) When the app syncs to the server, does it read all the data every time it saves each row? (I hope I'm phrasing that correctly). Some time ago, when we hadn't been able to sync for days, it would spend about three minutes syncing up each row. 

Thanks.

[TeeSee1 · Accepted solution]

the answer to a)

to b), maybe this answers it

https://help.appsheet.com/en/articles/962230-improving-the-speed-of-sync

[Charlie_Wells]

Thanks! I'll see if I can move read-only tables to their own file. 

As for (b): thanks - maybe delta sync would help, since there are no formulas getting data from external sources. I'll test that.

Thank you!