out of memory exception
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-03-18 11:01 AM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-03-18 05:04 PM
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.
