I have a dropdown that is fed into PHP by querying an Oracle database. It is working normally, however the amount it returns is 15000 records and each record is an option in the dropdown. This slows down and becomes unusable as well.
Simplified example:
<select class="form-control select2" name="classificacao_fiscal">
<option value=""> Selecione uma classificação fiscal </option>
<option value="1">Classificação 1</option>
<option value="2">Classificação 2</option>
<option value="3">Classificação 3</option>
<option value="4">Classificação 4</option>
<option value="5">Classificação 5</option>
...
<option value="14999">Classificação 14999</option>
<option value="15000">Classificação 15000</option>
</select>
Is there any other way to do this? Is there any component capable of "paging", that is, as I go rolling the dropdown, will it bring the next records?
I'm using select2 , where it has a searchbox for the user to filter those records.