Collections

[RafaelFernandes]

Hello everyone,

I have a process where a need to manipulate a collection whit more than 100k rows. I would like to know if, during running time, is faster to use the colletion in other pages of my process through Input/Output or without hiding from other pages ?

Thanks in an advanced !

------------------------------
Rafael Fernandes
------------------------------

[John__Carter]

I rarely use inputs and output between process pages and tend to use global data items instead. Passing large collections around as inputs and outputs can consume memory because you're creating more instances of the collection.

With large collections, you have to work within the capability of your machine, your network and of BP, and remember that none are infinite. If possible, it may be better to limit the number of rows coming into the process, for example by reading an Excel file via an OLEDB query that has a WHERE clause, rather than reading the whole data set and filtering it after bringing it into the process.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------