sircutbreaker
Top achievements
Rank 1
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
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
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
0
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.
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.