Hi,
Could I please get your thought on this issue please?
There is a table in sql server which has about 20 million records.
This table has an ID field called FileID.
Currently on a web page there are two text boxes used for FrilIDfrom and FileIDto. This as you know means that the user has to enter the FileID values in the text boxes.
I am thinking of using a drop down list instead of each text box. But the problem is it will take a long time for these drop downs to be populated for the FileIDfrom and FileIDto as there are over 20 Million records.
What is the best solution for this please
Thanks