System.OutOfMemoryException

[Rahul]

When we tried to export data from grid it give "System.OutOfMemoryException". It gives expception when we try to export 5000+ records.

No. Of columns in grid are 22
No of records need to fetch 5000+

Please help me how to resolve this issue.

[Krishnaprabhuraja]

Hi,

Check below forum post:
http://www.telerik.com/forums/export-to-excel-limit

Thanks,
Krishna Raja

[Princy]

Hi Rahul,

Its strongly recommend not to export large amounts of data since there is a chance to encounter an exception (Timeout or OutOfMemory) if more than one user tries to export the same data simultaneously. RadGrid is not suitable for such scenarios and therefore we suggest that you limit the number of columns and rows.
Unfortunately there is little that can be done when trying to export large amounts of data. You should have in mind that when IgnorePaging is set to true, RadGrid instance will be bound to 5000+ records which is quite memory consuming. Exporting and storing such large amount of data in session variable will cause scalability problem.
I can suggest you either to consider decreasing the amount of data or export only the current page by setting the IgnorePaging option to 'false'.

Thanks,
Princy

[Jayesh Goyani]

Hello,

Please check below links.
1. http://www.telerik.com/forums/radgrid-export-to-excel---out-of-memory-exception-error#m53Z6FhxoUa-xUUXmW68qg
2. http://www.telerik.com/help/aspnet-ajax/grid-export.html : 'Exporting a large amount of data'

Thanks,
Jayesh Goyani