Dropdown List with Large Data Set
Comments
- 
            
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.
 - 
            
Also, i have a Cache setup for it, but barely helps.
 - 
            
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.
 
Howdy, Stranger!
Categories
- 4.5K All Categories
 - 88 General
 - 13 Training
 - 214 Installation / Setup
 - 1.2K Flows
 - 112 Rules
 - 277 Administration
 - 215 Portal
 - 503 General Q & A
 - 722 Forms
 - 356 Reports
 - 3 Designer Extensions
 - 47 Example Flows
 - 58 CSS Examples
 - 1 Diagram Tile
 - 8 Javascript Controls
 - 190 Pages
 - 5 Process Mining
 - New Features
 - 187 Datastructures
 - 73 Repository
 - 238 Integrations
 - 30 Multi-Tenant
 - 27 SDK
 - 81 Modules
 - 60 Settings
 - 27 Active Directory
 - 12 Version 7
 - 37 Version 8
 - 143 Lunch And Learn Questions