Dropdown List with Large Data Set

Unknown

Dropdown List with Large Data Set

Unknown

I have a Dataset of Vendors that i need to load into a dropdown list for selection. there are over 14000 vendors to select from, these come from a DB query. This is taking very long to load and render and when the user hits the arrow, it freezes for a while.

Is there a recommended solution for Dropdown lists with large datasets? Maybe a type ahead load or something.

Unknown

Also, i have a Cache setup for it, but barely helps.

Unknown

Hi Christopher,

Ive replicated the set up and get the same issue. Ill raise a Developer Ticket for this to be reviewed and optimized for Drop Downs.

Another component which you could use here is the Auto-Complete Search Component. This takes in a list of Strings as input and depending on what the user types in, returns a possible set of results for the user to select. Plase refer our documentation for more info on this compoenent - [url=https://documentation.decisions.com/docs/using-database-populate-auto-complete-search-component]Auto-Complete Search Component[/url].

Let me know if this will work for your use-case.