Script execution time varies every time I run it

2019-09-13 08:15发布

问题:

Each time I run my script, it's execution times is significantly different from the previous run. The script is performing some custom validation on a ~500 rows sample sheet. The execution time varies from 7s to 300s. Interesting fact here is that this 300s is more than 5min (which I believe is the official limit, yes?).

Could anyone try to help me understanding this behaviour? Thanks in advance, Łukasz

回答1:

5 minutes NO, Your script will time out at 6 minutes.

Can you post the code? so I can better understand what your trying to achieve.

Are the different execution times your getting, always varied, when running your script on the same sample sheet, containing identical data? Or do the execution times only vary when the sample sheets data is different?

Are the custom validations your script is performing, changing each time you run your script?