I have just spent 4 hours, splitting my app with the 52 tables into a smaller app, with 32 tables, many of them read-only. The 32 table app references a spreadsheet file with each of those 32 tables only in it. This smaller app takes 31 seconds to sync. My app with the 52 tables in it, now references the spreadsheet with the 32 tables in it, as well as the original spreadsheet which has 52 tables (20 tables that are still referenced). This app syncs in 39-47 seconds. So I have saved 8 to 15 seconds per sync. I was not able to reduce the amount of tables in my smaller app, any more, without crippling the core functioning of my app.
Do you think SQL is my next step, and how much faster will it be?
Simon, which Appsheet parter do you work with?