Custom Picker /Dropdown For Larger Data Sets

Certified Lead Developer

Hi All,

Need some inputs on one of the business scenarios that we would like to implement:

There is a list of data (example: phone number) which user would like to select. The list can have n number of items (it can be in 100s as well).

Here the user does not wants to enter the number manually as mentioned above but instead type few characters and the matching one should appear. Since the list is/can be huge, we are facing performance issues while loading a dropdown or custom picker component.

Are there any known limits for using customer picker or dropdown component? Is there any better alternative to custom/picker or dropdown for this scenario?

Thanks.

Hitesh

  Discussion posts and replies are publicly visible

  • Hi Hitesh, 

    I believe you will be querying the data from a DB in the suggest function of the custom picker, If so, instead of running the query everytime when the user keys in a character, Add a logic in the suggest function to call the query entity only if the search text is 3 (use your desired value) or more characters long. 

    In this way, you wont call the QE very often and since the search text is big, the no. of results is filtered and will be less So you should see a quick response in custom picker.