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...
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