Solved: SQL vs Google Sheet - Page 2

mustafa1 · 01-27-2022 07:51 AM

Hi,

In my app, Google Sheet is used as the database. Not too big, around 30 tables and totally a few thousand rows.

I need a performance comparison of SQL vs Google Sheet.

The main problem is that. When I send data to Appsheet using API integration if I try to send a few rows at once (around 10 rows) API call takes too long (more than 30 seconds) and times out. (Note: Just one bot is triggered after adding the new row and it adds one more row. )

Can migrating to Cloud SQL solve this problem?

WillowMobileSys

@mustafa1 wrote:
The main problem is that. When I send data to Appsheet using API integration if I try to send a few rows at once (around 10 rows) API call takes too long (more than 30 seconds) and times out. (Note: Just one bot is triggered after adding the new row and it adds one more row. )
Can migrating to Cloud SQL solve this problem?

I don't believe switching datasources will make any difference. Remember, any API implementation coming in or even out of AppSheet will be going through AppSheet servers which likely have a copy of your data anyway.

I think something else is slowing down your API call. It might help to give more details about it.

Additionally, the size of data you have described is actually small in most regards. In my experience, with Google Sheets versus SQL database, there was no noticeable difference in the normal data operations within AppSheet with a data set this small. Larger data sets definitely have a noticeable performance difference

View solution in original post