I'm trying to improve the performance OR optimize the Win.UltraWinGrid.UltraGrid in our WinForm applications.

The query OR stored procedure can return up to 20K rows and more.

Also I have some conditions when returning smaller row counts:

public int Load(String Query, SqlParameter[] aParam, Infragistics.Win.UltraWinGrid.UltraGrid _UGrid)
{

    if (_UGrid.Rows.Count < 50)
     {
      _UGrid.DisplayLayout.PerformAutoResizeColumns(false, PerformAutoSizeType.AllRowsInBand, AutoResizeColumnWidthOptions.All);
     }
    else if (_UGrid.Rows.Count < 500)
     {
    _UGrid.DisplayLayout.PerformAutoResizeColumns(false, PerformAutoSizeType.VisibleRows,                AutoResizeColumnWidthOptions.IncludeHeader);
      }
    else
      {
      _UGrid.DisplayLayout.PerformAutoResizeColumns(false, PerformAutoSizeType.None, AutoResizeColumnWidthOptions.All);
     }

}

I understand that larger datasets perform slower when resizing/adjusting each row/column - we do use in additional some content specific formatting, like font-color or back-color 

I'm wondering if you guys have some advice OR performance, stress test results which can be provided in terms of best User Experience  when dealing with larger data sets? Is there any significant difference between 18.1 and 19.2 versions in this matter?

Also , I've been reading in other forum posts to lets say comment out this option here as well to get better results:

// _UGrid.DisplayLayout.Override.RowSizing = RowSizing.AutoFree;

Thank You for any suggestion.

Martin