Hi,
a question about the better way to set up the app database (in google sheets)
Is better organize in only one single sheet with 15/20/50 tabs or in 3 sheets with 5/10/20 tabs or all separate sheets?
change app speed? Or something else? Or is it the same?
Solved! Go to Solution.
Both options can be used. Please take a look at the articles below. Please note that these are all guidelines. An app performance is combination of many factors. For example the limits mentioned in the article on "Limits on tables per application" are not absolute limits.
How to use multiple sheets in your app - AppSheet Help
Please take a look at the section "Reduce the amount of data transferred "
Improve the speed of Sync - AppSheet Help
Limits on tables per application - AppSheet Help
Both options can be used. Please take a look at the articles below. Please note that these are all guidelines. An app performance is combination of many factors. For example the limits mentioned in the article on "Limits on tables per application" are not absolute limits.
How to use multiple sheets in your app - AppSheet Help
Please take a look at the section "Reduce the amount of data transferred "
Improve the speed of Sync - AppSheet Help
Limits on tables per application - AppSheet Help
Thank you I found the answer in the last link.
โPerformance also degrades when tables are stored in separate spreadsheet files.โ
You are welcome.
However, as mentioned all the guidelines need to be evaluated in the context of the type of data in the app, the usage pattern and so on.
One of the help article also mentions the following
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |