Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
8 subscribers
Views
3930 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, Any suggestions on how to make the user picker faster? Sometimes users
garym
over 8 years ago
Hi,
Any suggestions on how to make the user picker faster? Sometimes users are typing in a few characters and the "Working" message is flashing and it deletes what they typed. Other times it just takes so long for a matching result to appear.
I read a post about not having any max selections or group filter but that won't work for our form.
What about alternatives? Go back to the traditional drop-down?
Thanks
OriginalPostID-189211
OriginalPostID-189211
Discussion posts and replies are publicly visible
0
mohamedb
over 8 years ago
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?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rahul Gundu
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
garym
over 8 years ago
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?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Raviteja Varma Jampana
A Score Level 2
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mohamedb
over 8 years ago
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/.../
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
mohamedb
over 8 years ago
As for the groups, try to reduce group nesting by making you group structure as flat as possible. Hope this works.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rahul Gundu
over 8 years ago
Hi gary, 300+ active users on the environment.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rahul Gundu
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
garym
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Raj
Certified Senior Developer
over 8 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
>