Performance Tuning: Is appsheet reading all t...

(Colin) #1

Performance Tuning: Is appsheet reading all the data in each worksheet

Tony mentioned in Office Hours on 8 February 2018 that when Appsheet opens a spreadsheet, it is reading all the worksheet tabs that are inside it, regardless of whether they are added as tables or not. For those worksheets that are not added as tables, does that mean appsheet is reading all the columns and rows in that unused worksheet regardless?

(Santiago) #2

Hi @Colin yes, for most cloud providers the whole file needs to be read to obtain the tables that are part of the app. If you have significantly large sheets in the workbook that are not part of the app and can live as a separate file altogether, it’s better to break the workbook apart.