Select Options more than 50,000 rows
I have a database which got about 50 000 records. all is information of business partners.
I currently using
<select name="selection">
-- some while loop
<option></option> (repeat about 50,000 times)
-- end while loop
</select>
The issue is whenever I click on my dropdown, my browser will hang and crash. I think the records are too much.
For such cases, what is the best recommended implementation that can allow user to choose from the list of choice that is retrieve from database (about 50,000 choices) .
I need to do a form post to retrieve the ID of the selected option.