Solved Performance Discussion

[Abaddon]

I have two huge excel files to work with.

From a performance perspective what is better?
1) Import the whole file in a collection (since from behind the scenes BP uses SQL); or
2) Import line by, perform the tests that I need, and write the results and another excel file?

Thanks for the help.

 

[RDawson9]

Hi @Abaddon

Option 1 would almost always be preferable. Reading line by line would be extremely time consuming. It would be best to convert the Excel files into Collections and then perform all the operations inside Blue Prism, rather than interacting with Excel constantly.

Rob

 

[Abaddon]

Thanks for the help @RDawson9.