Winform Databinding Performance

Cslah posted on Wednesday, June 27, 2007

I'm finding some performance threads on the group here but not like I'd expect with what I'm experiencing, which leads me to believe I'm missing something slap-myself-in-the-forehead-obvious.

 

I'm binding a collection (BusinessListBase) to a winform DataGridView using Csla 2.1.4. I've only had to trap a few events to make it behave well and I generally have liked everything, until I load the collection with some records. Performance is to the point of my app being unusable. Even with something as small as 400 objects in the collection, it takes 10 seconds for the winform to pop up. If I load a collection with 1000 items it's unusable as it takes almost 45 seconds to load.

 

In tracking this down I've uncommented one line of code to find the bottleneck:

 

MyBindingSource.DataSource = MyCollection

 

The collection loads (even with 1000 items) in a few seconds. This one line of code kills everything else.

 

I've tried several things:

• Turning the BindingSourceRefresh to False
• Converting the collection to an EditableRootListBase (I actually handle some funny events to make the BusinessListBase work, which is fine)
• Making sure our objects have RaiseListChangedEvents turned off when fetching
• Make sure that none of my winform UI events are called when the datasource is being set.
• Turning RaiseListChangedEvents off before setting the datasource, then turning them back on afterwards and calling ResetBindings(False)
• I've even, just for a test, turned off RaiseListChangedEvents in my collection to see if things improve. They did slightly, but not near enough.
• As another test, I removed all of my columns except for 1 (string) and it seems reasonable. Note that I've only got about 8 columns.

Does anyone have any recommendations on how to improve databinding performance?