50000 rows into a combo!!! Which database engine are you using? Are you sure that it is the combo that takes all this time or can it be the data retreiving? Can you show the code you are using?
>I have 50000 records in my master table which I want to load in a third party combo box at run time(as per criteria provided). So I have bounded that control to increase the speed, but steel its taking 1 to 2 min's to load all values. I have also done indexing on that particular table.
>
>Can anyone please suggest me the better way to increase the speed.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com