I’ve always used Google Sheets for Apps. But I’ve got one App that sometimes is taking 1-2mins to sync. Especially on the first sync before delta-sync kicks in.
So I’m considering moving some or all of it to SQL. I’d be interested in knowing other peoples experience of this. Particularly in terms of the time this takes and the level of knowledge required. But also any performance improvements they noticed.
As far as I know you set the SQL database up as a data source, go into the table, select “copy data to new source”. But then do you end up with 2 tables of the same name? Do you have to copy over all the formulas?