population

Question

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

Answer 1

well you can look at this problem in this way you have a Database for WebA say DBa and database for WebB say DBb now when you insert a record in DBb in a table say t1 you can use an insert after trigger to insert the record in DBa table t1 for example. this will solve the problem May b.. isn't it intresting solution.