Maximum number of records in a collection

[TimsySangal]

Hi All,

What is the maximum number of records that can be stored in a Blue Prism collection. What is the most efficient way to compare data between two excel files containing a large number of records(approx 100000 per file)?

------------------------------
Timsy Sangal
Consultant
Capgemini
------------------------------

[John__Carter]

Reading them into collections and looping through is unlikely to be effective and may result in memory problems. I'd try something like an OLEDB query or even pushing the data into a DB so it can be queried there.

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