Scripted up a simple data transformation for school today in Google Sheets and App Scripts are slooooow. Like order of magnitude slower than running vbscript in Excel circa 2000. Is this normal?
1
Turns out that each operation is very, very, slow but the code speed isn't actually too bad. Basically: for must batch updates and then set values for large ranges at a time, or your code will run like molasses.
