Hi, Any suggestions on how to make the user picker faster? Sometimes users

1st - What type of picker are you trying to use?
User Picker
Group Picker
User & Group Picker
Document Picker
Folder Picker
Document & Folder Picker
Custom Picker

2nd- Do you experience slowness in page refreshes upon form submission in general or everything is working fine except for this picker component you are using?

Hi,
Below suggestion is one of the approach which I used before, Hope this will do better job.
Get the users which you want using a rule while loading the form and store it into a local variable, and use a custom picker in place of user picker. And populate the users using local variable in custom picker.

mohamedb - it is a user picker where we have a group filter...also a custom picker against a "vendor" table where a user can select from our vendor records

rahulg262 - thanks, approximately how many users did your application have to retrieve for that custom picker?

Hi Gary, speed can be improved by reducing the number of visible users to the loggedin user. It can be done by keeping him/her in restricted groups and planning groups by taking different entities of grouping.For example is we keep a person in 2 restricted groups say group by his region and group by his function/department than making him public we can restrict his visibility very well and he can be available in search easily. However there can be few cases where this approach is not possible but mostly it may.

Also, try adding an index in DB for the column containing unique "Vendor" identifiers; this can allow faster data retrieval. Something along this line:
www.siteground.com/.../

As for the groups, try to reduce group nesting by making you group structure as flat as possible. Hope this works.

Hi gary, 300+ active users on the environment.

In general, I used a custom picker for searching the data in database and it's works fine. It consists more than 1000+ rows. Where I used the same approach, getting the data using a queryEntity() and stored to local variable, and populating the data in a picker.

Just wondering if you have ever seen inconsistencies in the custom picker or user picker whereby it is faster for some users but for others it is just "Working" for a minute or more. They have the same computer but I can't figure out why it is quick for some and slow for others.

Another suggestion regarding the custom Vendor picker: if the business is okay with this, put a condition that the user has to type in at least certain number of characters. Even going from 1 to 2 characters will improve performance tremendously. I have had some use cases where we made the user type in 3 characters before we did a search in the database. For the first two characters, we would return a message asking users to type in at least three characters in the suggest function.