Maximum Size Export To Excel

2 posts, 0 answers
  1. sircutbreaker
    sircutbreaker avatar
    111 posts
    Member since:
    Oct 2007

    Posted 23 Jun 2009 Link to this post

    I have a grid and it contains about 1 million line items... I am very happy with the speed of processing when I sort, filter, etc... I have the data cached in a session variable.. and that makes everything run fast.

    However, when I try to export to excel, I am getting an

    Exception of type 'System.OutOfMemoryException' was thrown.

    The actual number of rows is around 800,000.. here is a snapshot of the schema for the grid...

    Table Schema

    What can I do to improve performance? What can I do to make the grid export to excel...

    and if there are too many items, what is the maximum size I can export?

    I am loading the grid using nettiers... I am on 3.5, controls are the latest build, and running sql 2005


  2. Pavlina
    Pavlina avatar
    6069 posts

    Posted 23 Jun 2009 Link to this post

    Hello Jeffrey,

    I suggest that you review the following forum link which discusses a similar issue. Go through it and see if it helps:

    the Telerik team

    Instantly find answers to your questions on the new Telerik Support Portal.
    Check out the tips for optimizing your support resource searches.
  3. DevCraft R3 2016 release webinar banner
Back to Top