How can data loading be sped up in AppSheet?

Hi all,

My Google Sheets file connected to AppSheet contains more than 24,000 rows, so the synchronization process takes a long time when the app starts. Is there any method similar to Lazy Loading that can speed up the initial load? For example, instead of loading all data at once, is it possible to load data gradually as the user scrolls down?

Thanks for help!

Nope.

4 Likes

In addition to @Steve ‘s advice, you will want to look at the Performance Profile of your app to understand WHERE the Sync time is being most spent. The image below shows you where you can find this log.

The quickest and easiest way to speed up Sync times is by using Security Filters, as suggested by Steve above.

Welcome to the next level of your AppSheet App Creation abilities!! :grin: :grin:

4 Likes

Hey,

Hope you’re keeping well.

AppSheet doesn’t support true “lazy loading” like infinite scroll, but you can significantly reduce sync time by limiting the initial dataset. Use Security Filters in Data > Tables to load only the rows relevant to the signed-in user or current context, and fetch additional data via slices or actions when needed. Also consider moving static or rarely used data to a separate table to avoid loading it every time. For datasets this large, connecting AppSheet directly to BigQuery instead of Google Sheets can improve performance, as BigQuery handles large volumes more efficiently.

Thanks and regards,
Taz

1 Like