Spreadsheet size and execution time

Each time a Phantom launches, it needs to load the input spreadsheet.

 

Some input files are a few hundred lines, but others are way bigger.

It takes about 1 second to load 1000 lines.

So, if your file is under 10k or 20k lines, that's fine. However, some of our users are loading files with 2M+ lines for each launch. This means 30+ minutes of loading time per launch!

Use smaller input files to save on your execution time; try dividing big files into sheets of 30k lines. 

Was this article helpful?
3 out of 3 found this helpful