I've a db table which contains 2 fields only, but has 45,000 of records, and now I have to load one of the field data into a combobox. if using the normal do-while loop and AddItem function, it takes quite some time to finish loading 45,000 of items. anyone know anyway to speed up the process ?
The typical code is :
while (not rs.EOF)
I have a Delphi program which loads this same amount of records in a very short time, how does it do this ?