Collections
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-03-18 12:13 PM
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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-03-18 01:33 PM
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-03-18 01:52 PM
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.