I set a dropdown as the ValueList for one of my columns. It now takes 10 times as long to load up my grid. It also takes 4 seconds just to move from row to row in the grid.
The grid has about 30 rows in it, and the dropdown has about 249. The DataSource of the dropdown is a SQL Server view via a BindingSource.
How can I get decent performance in this scenario?
Obviously, an UltraDropDown should not cause such a major performance hit. This is probably the result of some specific inefficiency about the way the dropdown is set up.
The first thing I would recommend is that you take a look at the WinGrid Performance Guide. In particular, you will want to look at section 3 which discusses ValueLists (UltraDropDown is a ValueList).
If none of the suggestions there help you, then see if you can duplicate the issue in a small sample project and I would be happy to take a look at it for you and see what's causing the performance hit.
I also found that if my display-member and value-member is the same, then the performance is fine.
Thanks Mike.
I reviewed that post and tried some things, but I still get the same behavior.
I have isolated the behavior is a VS project, and also extracted the required data to an Access accdb.
I have attached a zip with the project and data.
Thanks again