I have an html form which contains two drop downs.
Each drop down will have several thousand items (maybe upto 25,000)
I don't want to hard code the items into the HTML as the page will take ages to load. I think the answer is to populate the combo's from a database.
This raises a couple of questions:
1. Would this be more efficient than hard coding the items in the HTML?
2. How would I prevent the page re- querying the database upon page refresh? In otherwords, once the combo has been populated, there is no need to populate it again.
Has anyone got any thoughts on this, or has anyone done something like this before, and if so what was your solution?