Hi,
On a form I have 4 UltraCombos (2 x product code, product name) bound to a 2 properties (product1 code, product2 code) on a entity. The combos' data source is made of 20k product records. The combos are bound to 2 bindingsources, one for product1, the other for product2.
The editing form load extremely slow when the two properties on the entity is bound using DataBindings to the combo's values.
What can I do to speed it up?
The form is created only once, when the app is started. The products list is bound to the BindingSources at the same time. The form is shown only when the user add a new entit, or modifies an existing one.
I'm a little fuzzy on exactly how you have thing set up. You say you have 4 UltraCombos bound to 2 properties? How does that work? The other two combo's are unbound?
When you say ' bound' are you referring to the list? Or are you binding the Value or Text property on the control? If the latter, does not binding the ValueText make any difference to the performance?
Does the form load faster if you don't bind the Combos, but still load the data from the data source?
Are you handling any events on the combos?
Have you read the WinGrid Performance Guide? UltraCombo is derived from the same base class as UltraGrid, so many of the same performance issues apply.
Also, what version are you using?
Hi Mike,
I have 2 sets of combos: cboProductCode and cboProductName, both of them have data binding to the entity's ProductCode property:cboProductCode.DataBindings.Add("Value", _entityBindingSource, "ProductCode"); cboProductName.DataBindings.Add("Value", _entityBindingSource, "ProductCode");
I have also tried binding the cboProductCode to the entity's property and the cboProductName to cboProductCode's value: cboProductCode.DataBindings.Add("Value", _entityBindingSource, "ProductCode");cboProductName.DataBindings.Add("Value", cboProductCode, "Value");
The combos have the data source a binding source which is linked to a list of 20k records. When I say "bound" I mean the data source of the control is linked to a BindingSource which is linked to a list.
I don't see any difference in loading the form when the property has a data binding to combo or not. If the _productBindingSource is not linked to the list of records the form load instantly.
I am not handling any events on the combos. I am using the last version of controls, 12.2.20122.2027, on .NET Framework 4.0 Client Profile. Also my computer is quite new: a i5-3550 processor, a intel 330 SSD and 4GB of RAM.
And I have read the WinGrid Performance Guide on the day you have published it, and any time I get into performance issues in my apps.