https://community.blueprism.com/t5/Product-Forum/Maximum-number-of-records-in-a-collection/m-p/83413#M34693 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.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Fri, 11 Dec 2020 15:29:00 GMT John__Carter 2020-12-11T15:29:00Z https://community.blueprism.com/t5/Product-Forum/Maximum-number-of-records-in-a-collection/m-p/83412#M34692 Hi All,<BR /><BR />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)?<BR /><BR />------------------------------<BR />Timsy Sangal<BR />Consultant<BR />Capgemini<BR />------------------------------<BR /> Fri, 11 Dec 2020 13:42:00 GMT https://community.blueprism.com/t5/Product-Forum/Maximum-number-of-records-in-a-collection/m-p/83412#M34692 TimsySangal 2020-12-11T13:42:00Z https://community.blueprism.com/t5/Product-Forum/Maximum-number-of-records-in-a-collection/m-p/83413#M34693 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.<BR /><BR />------------------------------<BR />John Carter<BR />Professional Services<BR />Blue Prism<BR />------------------------------<BR /> Fri, 11 Dec 2020 15:29:00 GMT https://community.blueprism.com/t5/Product-Forum/Maximum-number-of-records-in-a-collection/m-p/83413#M34693 John__Carter 2020-12-11T15:29:00Z