hi friends,

wat kind of technique iv to use to filling speed of combo boxes.
it takes much time.

*) i have a database of .5 million records.
*) .5 million records are stored in 10 combo boxes.
*) each combo box is filled with different criteria.
*) im using asp scripting for filling the combo boxes.
*) it takes 1 minute on web server.
*) it takes 15 minutes on LAN(other than web server).