Reputation: 31
Is there any replacement to Dataset, so Data is saved to the disk, rather than stored in memory? I have to populate a dataset with an enormous amount of data, which can cause Out Of Memory exceptions. There is nothing I can do to reduce the amount of data as it’s driven by user requirements.
Upvotes: 3
Views: 1009
Reputation: 700670
I would check if it would be possible to use a DataReader
instead, as you then would process the records as they arrive from the database instead of first storing everything in memory.
Upvotes: 1