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.
Mike Saltzman"]Tabbing into the combo the first time is rebuilding one of these lists, and that's why it's slow. I'm not sure why it's doing that, since the list is already built. There must have been some change to the list at some point after it was built the first time. Is your code making changes to the data source data at any point?
The list that is the data source of the combos does not change at all.
Another problem is that the lag is present when using Linear search mode, when an existing record is shown, like I mimicked in the new sample attached.
ehaisiuc said:Another problem is that the lag is present when using Linear search mode, when an existing record is shown, like I mimicked in the new sample attached.
I can understand why the combo is slow in linear search mode, because it has to find the matching value on the list and it does so using a linear search. So it may have to search through all 20,000 items if the item it not found on the list.The closer the matching item is to the bottom, the slower it will be.
The combos where unusable in my situation. I ended up replacing them with UltraTextEditors and did the search and filter myself. It became usable even on 7-10 years old computers with Windows XP SP2 and 512 MB of RAM.
can u give me you solution pls , i have same situation here with 72k items i must add them in combo .
Hi Esam,
My solution was tightly linked to the client's problem. I have replaced the combos with UltraTextBoxes and I've stored my data in a couple of dictionaries used for finding the value associated with the text the user entered. So I cannot give you a solution on using the combos, because I have worked around them, and I was not able to find a solution to make them work.
Regards
Hello Esam,
esam_rabba said: ... my suggestion is , on demand or on user enter a first part of word in combo box , a small logic must run to get a filtered view of data and attaching it to combo box and drop down the grid under it
If you take a look at the second UltraCombo control in my sample, you will see that I`m using Linq to filter our huge data depending of the value from first combo control. I do this using AfterDropDown event and second thread. Of course you could modify this scenario and filter your data depending of the text that your user type in the combo. Also if you get your data from database, you could use Dynamic SQL to create your query with required filter conditions.
Let me know if you have any questions.
REgards
I was thinking of exactly the same solution, but for that project I didn't had the time to do it. If a nice solution is suggested I would certainly use it in a future project, or on an upgrade.
Regards.
Hi All ,
Thanks a lot for both interaction in this subject , but i think attaching this a mount of data to combo box in any way will takes time and give a feeling of heavy in the form ,
let talk in another way , my suggestion is , on demand or on user enter a first part of word in combo box , a small logic must run to get a filtered view of data and attaching it to combo box and drop down the grid under it.
Hi Georgi,
Your sample doesn't touch the issue I found, and, from what I have understood, Esam has.
My problem is that when the combo is used as an edit control (to edit a property on a business entity) and has a lot of rows (linked to a more complex entity, with more than 2 columns) the initial drop down of the combo takes really long to show.
I have modified the sample you have attached to include the data binding of the combo with a business entity. Now, after the combo loads, clicking the down arrow takes about 3-4 seconds for the drop down to be displayed. In that lag time, the whole form freezes. After that the combo is responding great. In order to use the combo like an edit control I have to get rid of the initial lag.
This is the sample