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