I've tried using the current version of Sheets App Script for some advanced busi... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		falcor84 on April 12, 2019 \| parent \| context \| favorite \| on: Google makes BigQuery available in Sheets I've tried using the current version of Sheets App Script for some advanced business functionality, but it's horrendously slow - taking over 10 seconds to loop over just 5000 rows. And they're using an ancient version of js, making development annoying. I really hope that this announcement would herald a renewed interest on their side in improving Sheets as a whole.

pcmaffey on April 12, 2019 [–]

Yes, I found it much faster to do everything in memory, minimizing the number of reads/writes.

And it was a bit of shocker writing es5 js again.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact