This is a migrated thread and some comments may be shown as answers.

Maximum Size Export To Excel

1 Answer 36 Views
Grid
This is a migrated thread and some comments may be shown as answers.
sircutbreaker
Top achievements
Rank 1
sircutbreaker asked on 23 Jun 2009, 02:10 PM
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

Thanks!


Jeff

1 Answer, 1 is accepted

Sort by
0
Pavlina
Telerik team
answered on 23 Jun 2009, 03:06 PM
Hello Jeffrey,

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

Greetings,
Pavlina
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.
Tags
Grid
Asked by
sircutbreaker
Top achievements
Rank 1
Answers by
Pavlina
Telerik team
Share this question
or