Does the sync time gets affected based on the...

(Tejaswini Yarramaneni) #1

Does the sync time gets affected based on the type of data sources we are using . I am use Sql database on azure as a data source . The sync time is around 20 seconds approx . I tried changing the data source to google sheet containing the same data as on Sql and the sync time reduced to 10 seconds approx . Is this something usual or are there ways to enhance the performance when using sql ?

Thanks!!

(Dinh Nguyen Nguyen) #2

@Tejaswini_Yarramanen Hi Tejaswini, how many rows are there in the SQL database and in the Google sheet? Also, is there any potentially long-running trigger or stored procedure in the database?

(Praveen Seshadri (AppSheet)) #3

It is also possible that the location and nature of the sql database matters. Some of the free Azure sql databases are really slow because they have to be spun up on each use. This is not the case for the higher-end paid Azure sql databases

(Tejaswini Yarramaneni) #4

@Harry

Approx 10000 rows . There are no such triggers and sprocs on the database .

(Tejaswini Yarramaneni) #5

@praveen I am thinking this might be the issue . We have purchased a Basic SQL Tier on azure which just comes with 5 DTU’s. That might be causing the performance issues . So does this mean google sheets have minimal performance issues . Because they seem to act very fast . Thanks For the idea!! We ll try looking into sql databases with much performance benefits.

(Praveen Seshadri (AppSheet)) #6

You’ll find Google Sheets is pretty fast. But a good SQL database set up correctly will be even faster if there is any filtering of data happening (eg: a security filter in your app)