I am trying to improve SYNC times and need some advice.
I am using Google Sheets for my database and currently have 18 tables with over 50 views in a single APP. I use some Dashboards which allows me to
group views on the main MENU of views although this isn’t ideal. I wish AppSheet allowed some kind of a hierarchical viewing system so that we could categorize views. All the tables are Read Only.
I did most of my views inside of Google Sheets using query. The 1st tab in the Workbook contains the raw data and additional tabs were added to represent different views of the data using query language against the raw data tab.
Now that I understand AppSheet better I realize that I can reduce the number of tables significantly by reducing the number of tabs in Google Sheets and using Slices inside of AppSheet to do my queries.
This will require some effort on my part so my question is, will this improve Sync times enough to make it worth the effort to change over? Right now users are experiencing 60 to 90 second SYNC times.
Some source data in Google Sheets changes once a week requiring the users to Sync once a week.