WebGrid Exporting very slow on large datasets

mdearman@libera.com — Thu, 08 Jul 2010 14:44:49 GMT

I have this same problem.

I ended up having to stop the user from exporting this many records to the grid's built-in export formats and try to directly read the DataView of the DataSet and manually export to a format like CSV (streaming to disk).

I would love a long-term solution to exporting to Excel. Although I'm not sure Excel can handle more than 65K rows?

Mike

WebGrid Exporting very slow on large datasets

tlusby — Thu, 08 Jul 2010 10:55:04 GMT

I have a webgrid that is displaying 165,000 rows. The grid returns the results in about 5 seconds. I exported the values in EXCEL using the built-in Export functionality, and I have been waiting for 15 minutes. Is there a limit to how many rows you can export at a time?

NOTE: I got an out of memory error after 20 mintues.


<LayoutSettings AllowAddNew="No" AllowColumnSizing="Yes" AllowColumnMove="Yes" AllowDelete="No" AllowEdit="Yes" AllowExport="Yes" AllowFilter="Yes" AllowGrouping="No" AllowSelectColumns="Yes" AllowSorting="Yes" GridLineColor="#CCCCCC" GridLines="Both" GridLineStyle="Solid"
PagingMode="ClassicPaging" PagingSize="500" AllowBatchUpdate="true" PagingStyleUI="Slider" AllowMultipleSelection="No" GroupByBoxVisible="false" HeaderClickAction="SortMulti" VerboseEditingInformation="true" NewRowLostFocusAction="AlwaysUpdate" FocusNewRowOnLastCell="true"
AllowColumnFreezing="Yes" ApplyFiltersKey="Enter" EditOnClick="True" AutoHeight="false" AutoWidth="false" AutoFilterSuggestion="true" PagingExportMode="ExportAllData" ShowFilterStatus="true"
InProgressUIBehavior="ChangeCursorToHourGlass" ColumnFooters="Yes" HeaderWrapDefault="true" ColumnFooterAggregateMode="CalculateAllData" ShowColumnAction="true" PersistRowChecker="true" RestoreRowSelection="All">

protected void WebGrid1_Export(object sender, ExportEventArgs e)
        {
          e.ReportInfo.EnableValueList = true;
        }

Intersoft Community - WebGrid Enterprise - WebGrid Exporting very slow on large datasets

WebGrid Exporting very slow on large datasets

WebGrid Exporting very slow on large datasets