I'm trying to design a widget which is a dropdown single selection containing a very large set of data. Because there could be 2000 records in the dropdown. Loading them at once will make the system very slow. So below is my first path. This widget is used to select an option in the database.
By default, it looks just like a dropdown. When users click in the field, the dropdown list will open and a cursor will appear in the field. The 2000 options are divided into pages and that's why you see the pagination at the bottom.
When people type in the field, it will filter/auto-suggest matching results. The total number will reduce to 1000. If people also use the filter on the search result, it will reduce to 50.
However, I'm not sure if the pagination is really helpful to people who want to pick an option. I don't think they'll ever use pagination when there are 1000 of them. The reason I keep it here is because sometimes people might not know what to type in the field...
Here is another option: Add a "More" button at the bottom and get rid of pagination. Any thoughts, comments or suggestion?