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.
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
Hi Esam,
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.
Regards
This is the sample