Choosing Your Data Provider
Google Sheets is More Efficient than Excel
Google Sheets is more efficient than Excel for the following reasons:
- When AppSheet updates Google Sheets it only writes the updated rows. When AppSheet updates Excel it must write the entire workbook.
- When AppSheet reads Excel worksheets it must re-compute all worksheet formulas. This is not necessary for Google Sheets because it automatically re-computes the worksheet's formulas when we update the worksheet.
Organizing Your Worksheets
Only include worksheets in the workbook that the application requires
A workbook contains one or more worksheets. AppSheet reads workbooks in their entirety. You can improve performance by eliminating any worksheets from the workbook that the application does not use.
Isolate read-only worksheets in their own workbook
If your application uses read-only worksheet, you can improve performance by isolating all read-only worksheets in their own workbook.
Make the AppSheet tables for these read-only workbooks "READ_ONLY". Do this by opening the editor, selecting the Data > Tables tab, clicking on the table, and setting the table's "Are updates allowed" property to "READ_ONLY".
Enable server side caching for read-only tables. This reduces the number of times the read-only tables must be retrieved from the Cloud Provider.
Delete empty rows at the bottom of worksheets
If your worksheets contain hundreds or thousands of empty row, you can greatly improve performance by deleting them.
Delete empty worksheet columns including columns to the right
If your worksheets contain empty columns, you can greatly improve performance by deleting them.
Minimize Worksheet Formulas
Minimizing worksheet formulas improves performance for both Google Sheets and Excel.
Minimizing worksheet formulas is especially important for Excel because these formulas must be re-computed by the AppSheet Server each time the Excel worksheet is read. This can be very expensive if:
- You have large numbers of worksheet formulas
- The worksheet formulas are complex.
- The worksheet formulas rely on external services.
Configuring Your Application
Use Security Filters
Use Security Filters when possible. Security Filters can reduce the number of data rows sent from the AppSheet Server to the AppSheet Client. This reduces network traffic, improves responsiveness, and reduces the storage space used by the AppSheet Client.
Security Filters are especially valuable for SQL. AppSheet forwards the Security Filters to SQL which may greatly reduce the amount of data SQL must return.
Consider Enabling Delta Sync
Enabling Delta Sync will avoid unnecessary reads between the AppSheet Server and the Cloud Provider. Read will only be performed if the data stored on the Cloud Server has change since the AppSheet Server last read the data.
Consider Enabling Delayed Sync
When Delayed Sync is enabled, changes are queued on client until the user triggers sync. When sync is triggered, the changes are sent from the AppSheet Client to the AppSheet Server and all changes are applied before the updated tables are re-read from the AppSheet Server. This can reduce the number of times the updated tables are re-read.
Before enabling Delayed Sync, make certain that delaying synchronization will work for your application. For many applications it is important to apply changes as soon as possible.