To test the sync time, I tested just one table with exact same data in Google Sheet vs Google Cloud SQL - both about 60K rows with no relationships and no virtual columns and formulas - plain static data. I was hoping that SQL will be much faster. It turns out that it reads from SQL much faster but data conversion takes much longer - which leads to SQL being slower than Google Sheet. I have the exact same data type in both tests - not sure why it is converting SQL data and not Sheet data.
SQL is taking about 20 seconds when Sheet is about 6 seconds. In case of SQL data, 16 secs is spent just on data conversion. Any ideas/suggestions to avoid this data conversion when I am accepting the default column types that Appsheet generates?
Please see attached screenshot.