Does it speed up an app to have your Google Sheet tables in separate Google Sheets?

Hi, I was talking to another Appsheet developer the other day and he said, in his experience, when you have lots of users using your app, that he discovered that having each of his tables in their own google sheet meant that there were less users interacting with each google sheet, rather than all of them on one google sheet.

I was wondering if anyone else has found this to be true too, as I have not been doing this and I am building a new app that I know will have many users and I would like it to work as effectively as possible.

0 1 61
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

As far as I know, that won't speed up the app.

However, that can speed up to set the "stable" dataset on another Sheets, if you use the option "Server Caching" in your app settings. Because the "last updated data" will be loaded, and the document timestamp is a part of reasons for loading data or not.

Here are more informations:

Improve the speed of Sync - AppSheet Help

 

Top Labels in this Space