WebGrid Exporting very slow on large datasets

1 reply. Last post: July 8, 2010 2:44 PM by Mike Dearman
Tags :
  • (None)
  • New Discussion
  • New Question
  • New Product Feedback
T LusbyMember

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;
        }
 
 
1 attachment
All times are GMT -5. The time now is 11:24 PM.
Previous Next