Hello Paul

I have opened a support request for this forum post so we may research this behavior further.   Please use the following link to log onto your account at Infragistics.Com:

<https://ko.infragistics.com/Membership/MySupport.aspx>

Once you are logged onto your account, go to My Support Activity to view the progress of this support request.  An update will be sent to you in the support request with any new information we find.

Please let me know if you have any questions.

Ok, that is what I thought. This should probably be investigated by the ASP.NET team to see if they can make any improvements to the exporter. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.

Ok,  I wrote an export method that builds the infragistics workbook and worksheets manually as opposed to using the infragistics exporter to push data to the workbook.  This method cut the time down to 32 seconds per 10K rows and reduced the memory usage to about 400M (down from 2G).  It is now doing a 20K row 57 column export in about 1M 4s.  This same export was taking anywhere between 2M 24s to 2M 54s with the exporter.  So I think the major culprit is the exporter.

This is definitely more acceptable in terms of time and memory.  Here is the code:

private static bool AddDataToWorksheetManual(UltraWebGrid grid, Worksheet sheet, int StartRow, bool processColumns)
{
 DisplayFormatList format = new DisplayFormatList();
 int icols = 0;
 int irow = StartRow;
 WorksheetRow headerRow = null;
 if (processColumns)
 {
  foreach (UltraGridColumn col in grid.Columns)
  {
   if (irow == StartRow)
    headerRow = sheet.Rows[irow++];
   WorksheetCell wscell = headerRow.Cells[col.Index];
   wscell.Value = col.Header.Caption;
   wscell.CellFormat.Font.Bold = ExcelDefaultableBoolean.True;

   WorksheetColumn wscol = sheet.Columns[icols++];

   if (col.HasCellStyle)
   {
    if (!string.IsNullOrEmpty(col.Format))
     wscol.CellFormat.FormatString = format.GetExcelFormat(col.Format);

    if (col.CellStyle.HorizontalAlign != System.Web.UI.WebControls.HorizontalAlign.NotSet)
     wscol.CellFormat.Alignment = TranslateAlignment(col.CellStyle.HorizontalAlign);
    
    wscol.Width = (int)sheet.Workbook.PixelsToCharacterWidth256ths(col.Width.Value);
   }
  }
 }

 
 //Loop through rows to set data and attributes
 foreach (UltraGridRow row in grid.Rows)
 {
  WorksheetRow wsrow = sheet.Rows[irow++];
  if (row.HasStyle)
  {
   if (!row.Style.BackColor.IsEmpty)
   {
    wsrow.CellFormat.FillPattern = FillPatternStyle.Solid;
    wsrow.CellFormat.FillPatternForegroundColor = row.Style.BackColor;
   }
  }

  int icell = 0;

  //Loop through cells in the row setting the cell level attributes and values
  foreach (UltraGridCell cell in row.Cells)
  {
   WorksheetCell wscell = wsrow.Cells[icell++];
   wscell.Value = cell.Value;

   if (cell.HasStyle)
   {
    if (!cell.Style.BackColor.IsEmpty)
    {
     wscell.CellFormat.FillPattern = FillPatternStyle.Solid;
     wscell.CellFormat.FillPatternForegroundColor = cell.Style.BackColor;
    }

    if (!string.IsNullOrEmpty(grid.Columns[icell - 1].Format))
     wscell.CellFormat.FormatString = format.GetExcelFormat(grid.Columns[icell - 1].Format);

    if(cell.Style.HorizontalAlign != System.Web.UI.WebControls.HorizontalAlign.NotSet)
     wscell.CellFormat.Alignment = TranslateAlignment(cell.Style.HorizontalAlign);
    else if(grid.Columns[icell -1].CellStyle.HorizontalAlign != System.Web.UI.WebControls.HorizontalAlign.NotSet)
     wscell.CellFormat.Alignment = TranslateAlignment(grid.Columns[icell -1].CellStyle.HorizontalAlign);
   }
  }
 }
 return true;
}

private static HorizontalCellAlignment TranslateAlignment(System.Web.UI.WebControls.HorizontalAlign alignment)
{
 switch (alignment)
 {
  case System.Web.UI.WebControls.HorizontalAlign.Center:
   return HorizontalCellAlignment.Center;
  case System.Web.UI.WebControls.HorizontalAlign.Justify:
   return HorizontalCellAlignment.Justify;
  case System.Web.UI.WebControls.HorizontalAlign.Left:
   return HorizontalCellAlignment.Left;
  case System.Web.UI.WebControls.HorizontalAlign.NotSet:
   return HorizontalCellAlignment.Default;
  case System.Web.UI.WebControls.HorizontalAlign.Right:
   return HorizontalCellAlignment.Right;
  default:
   return HorizontalCellAlignment.Default;
 }
}