DataGridView - slow

DataGridView - slow

• TechFreak

  FWIW, I agree. It's especially bad if you set the backcolor of individual cells. I read in one of the many books I have that setting certain cell and/or row styles causes rows to become unshared (or something like that), affecting (at least) memory, and probably performance. In any case, since the painting doesn't seem to get much worse once the screen fills up, I'm hoping it's fairly independent of the total number of rows in the grid.
  
  Column auto-size rapidly gets slow as the grid fills, if you're sizing to the entire grid. I hope the speed issues are addressed before release.
  
  ---Mike
  
  

• ctlok83

  I can't confirm this. I have 3GHz dual core Pentium D and 2GB of RAM here and the scrolling is laggy for me as well.
  
  

• Rajpreet Singh

  The scrolling-problem is directly releated to your CPU power. I have an old 1.7Ghz Xeon and have jerky and laggy scrolling in the DataGridView. A college here have a new machine. 3GHz Xeon and the scrolling goes as fast as I would expect on my machine.
  
  As we are developing windows clients for the future (in production in 2-3 years) I can accept this performance since I would expect our customers at least having 3GHz PCs at that time.
  
  I will still have this old 1.7GHz in 3 years but that just because this company is worse than goverment bureaucracy slowness and to get a new PC I probably would need to get fired and re-hired after someone else adopted this PC :)

  
  
  

• Test Me

  btw, I just noticed that it's not actually about the amount of rows loaded but about those shown ... if i make my app very small and the grid's height decreases, I get back to the performance I get when the grid is empty. Is there anything I can do on this as the old DataGrid doesn't seem to have that problem
  
  

• Torsten Grabs

  MortenFraMoss wrote:

  My problem is solved on RC1 :)

  
  That's good to hear. I tried RC1, but found it crashes more than Beta, and also some API parameters changed without generating a compiler error, so I'm waiting for the next release before making the change.
  
  ---Mike
  
  

• Aziir

  Done some preliminary tests on DataGridView first on Beta2 and now on RC1 and I don't see any performance improvements, maybe a bit slower in RC1 (! ).
  
  Filling the grid with bound (DataTable) or just pushing cells with text goes acceptable fast even with 10.000 rows but scrolling is WAY to slow and jerky. You might think that 10.000 rows is a bit much but when trying with 300 rows the same slow scrolling problems appears.
  
  Cannot compare with the grid in .net1.1 since then we still used a wrapped c++ grid. But a simple google on datagrids I found a OCX one that is blazingy fast even with 50.000 rows.
  
  We would prefer not to use any 3rd party components but if the DataGridView is so slow that would become our only possibility.
  
  There must be some huge bug in the grid component and if that is not adressed before final release of VS2005 I cannot recommend using the new grid to anyone.
  
  You don't need any advanced test project to test this, just drop a grid on a form and set rowcount to 1000 or something and loop in some strings in the cells and the performance problem is very apperent directly.
  
  

• smith288

  I just need 5 rows with 5 columns to make DataGridView way to slow. I can actually see the grid is being redrawed.
  
  What kind of processors do you guys have Maybe this component is very slow on non-HT processors or something.
  
  

• IanTedridge

  My problem is solved on RC1 :)
  

• Cheese

  Tom - have you tried this out on builds other than Beta2 We have made some performance improvements since then. I can also try this out if you want, if you can send me your project to markri <at> microsoft dot com.
  
  thanks,
  -mark
  DataGridView Program Manager
  Microsoft
  This post is provided "as-is"
  

• NZ Dev

  Hi Mark,
  
  yes, I also tested on C# Express RC today. Performance looks a bit better though still not at the level of the DataGrid 1.1 control. Sorry but I can't really shoot you the solution because it needs 3rd party login, etc. to pull in data.
  
  Regards,
  
  Tom
  
  

• ComputerGuru

  Unfortunately, I found this here today: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx feedbackid=6c40681e-f10e-4ea5-8d59-0942fb4bc921
  
  So, I guess they are not and looks like I have to use another grid control as this is not acceptable for me.
  
  

• les_ihs

  you guys got any other ideas what I could do to improve performance
  For example, I converted this article over to the new DataGridView:
  http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnwinforms/html/dragdrop_datagrid.asp
  However, draggin my columns when like 100 rows and 10 columns are loaded is awfully slow. Dragging them on the old DataGrid with 500 row and 10 columns is blazing fast
  
  

• SAlekseev

  This is true. I also SuspendLayout, set Enabled false, and whatever else shows up on the intellisense.
  
  I did just find that using the CellPainting event is death. I moved it into the CellFormatting and it's much faster, although you cannot use cell.FormattedValue in there, apparently due to recursion.
  
  ---MikeB
  
  

• dlt

  I've seen the same performance issue.  One thing to try is turning off events while the dataset is loading.  For example:
  
  

  Me.TblSupplementsBindingSource.RaiseListChangedEvents = False Me.TblSupplementsTableAdapter.Fill(Me.DStblSupplements.tblSupplements) Me.TblSupplementsBindingSource.RaiseListChangedEvents = True Me.TblSupplementsBindingSource.ResetBindings(False)

  
  
  Made a big difference for me.
  
  DaveL

  
  
• DataGridView - slow