System.OutOfMemoryException

4 posts, 0 answers
  1. Rahul
    Rahul avatar
    142 posts
    Member since:
    May 2009

    Posted 08 Apr 2014 Link to this post

    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.
  2. Krsnaraja
    Krsnaraja avatar
    9 posts
    Member since:
    Aug 2007

    Posted 08 Apr 2014 in reply to Rahul Link to this post

    Hi,

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

    Thanks,
    Krishna Raja
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Princy
    Princy avatar
    17421 posts
    Member since:
    Mar 2007

    Posted 08 Apr 2014 in reply to Rahul Link to this post

    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
  5. Jayesh Goyani
    Jayesh Goyani avatar
    2732 posts
    Member since:
    May 2010

    Posted 08 Apr 2014 in reply to Rahul Link to this post

    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
Back to Top