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.
It's better to have one google sheet with multiple tables with some caveats:
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:
So there's a little performance boost you can get from have a smaller number of files.
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |