Collections

[Sundharpasuvaye]

Hi All, How many data we can fetch in collections in a time any max limit is there? As per my requirement we have more than a laks of  rows data in the Excel, if I fetch via collections it get hanged and thrown an error €œStack empty€ pop up message.   Thanks      

[NaveenG]

With My knowledge.... you can fecth maximum data in to excel sheets... If you want to process excel data with large amount number then You need to use QUEUE concepts.. --Naveen

[John__Carter]

Some of the main risks with enormous collections are 1) PC memory limit is reached, 2) excessive data logging and 3) a slow running process. If you have a giant Excel file then it might be better to consume it in a more efficient way, perhaps using an OLEDB query instead of opening the file and reading an entire sheet in one go.