Which is better for app performance and lesser sync times

Say if the app contains 15 Tables, for better app performance and lesser sync times which one of the following is a better option

1. Separate Google Sheet with a single sheet for each table i.e. 15 Google Sheets

2. Single Google Sheet with 15 sheets

I have this doubt now after reading some posts in the community.

When the data in only one Table is modified and I have Server Caching and Delta Sync enabled for my App, which one of the above options work better. 

1 3 183
3 REPLIES 3

It's better to have one google sheet with multiple tables with some caveats:

https://support.google.com/appsheet/answer/10104985?hl=en

This is a weird question because in general neither of those affect performance as much as other configs.

The recommendation is that you should leave the Read Only tables on it's own file, this will help with the server caching.
Other than that, there is no bigger performance killer than Virtual Column checking the whole tables


@SkrOYC wrote:

This is a weird question because in general neither of those affect performance as much as other configs


True, but they still have an effect.  Just consider the following:

  • If my app has 15 separate files connected to it... 
       - Then my app has to find & open 15 separate files
  • If my app only has 1 file, with 15 tabs...
       - Then my app only has to find & open the one file
       - The other 14 tables come from the already opened file

So there's a little performance boost you can get from have a smaller number of files.

Top Labels in this Space