cancel
Showing results for 
Search instead for 
Did you mean: 

out of memory exception

AmitPatnaik
Level 4
I have tried to parse excel file with more than 9000 records The parsing is getting complete but when I tried to open the collection it's giving me the exception.  
1 REPLY 1

Denis__Dennehy
Level 15
There are knowledgebase articles on this.   The root cause can be found by doing an internet search for '.NET datatable out of memory' - it is how .NET handles large blocks of data in datatables (which is effectively what a collection is), the solution is to reorchestrate your solution to handle smaller bits of the data at a time and also the knowledgebase article has advice about removing rows and invoking the garbage collector.