Performance with Google Sheets 17500 records

AppSheet AppSheet Q&A
1

Hello, I currently have a client populating a multi tab Google worksheet. All tabs are reasonably populated - nothing extraordinary except for their main use table where they populate reporting data for their clients. In a matter of two weeks they’ve posted 17500 records. It currently takes 45min-1hour to post records to the table with the sync.I understand server caching is an option but the reporting table is literally in use all day.

I’ll be discussing archiving records etc but how else can I significantly improve performance? Any ideas would be greatly appreciated. Thanks!

Here is a quick screenshot of the performance analyzer:

2X_e_ecde9e6dedf7e3ced1e2fc38f2cfa3cbc8cd6aa0.png
2X_e_ecde9e6dedf7e3ced1e2fc38f2cfa3cbc8cd6aa0.png1062×928 46.5 KB

2

@Daisy_Ramirez Hi Daisy, you can find suggestions on how to scale your app to handle lots of data in the article below. However, since the number of rows is in the tens of thousands and growing, I suggest that you use a SQL database instead of Google sheets as the data source of your app.

https://help.appsheet.com/performance-scale-reliability/scaling-to-large-data-sets/approaches-to-data-scalability