This is a migrated thread and some comments may be shown as answers.
System.OutOfMemoryException
3 Answers 62 Views
This is a migrated thread and some comments may be shown as answers.
Rahul
Top achievements
Rank 1
Rahul asked on 08 Apr 2014, 12:23 PM
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.

3 Answers, 1 is accepted

Sort by
0
Krishnaprabhuraja
Top achievements
Rank 1
answered on 08 Apr 2014, 12:44 PM
Hi,

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

Thanks,
Krishna Raja
0
Princy
Top achievements
Rank 1
answered on 08 Apr 2014, 12:45 PM
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
0
Jayesh Goyani
Top achievements
Rank 2
answered on 08 Apr 2014, 12:46 PM
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
Tags
Grid
Asked by
Rahul
Top achievements
Rank 1
Answers by
Krishnaprabhuraja
Top achievements
Rank 1
Princy
Top achievements
Rank 1
Jayesh Goyani
Top achievements
Rank 2
Share this question
or