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
7 replies
Subscribers
9 subscribers
Views
5749 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Max limit for pickerFieldCustom
ajinkyab277
Certified Lead Developer
over 8 years ago
Is there any best practice around pickerFieldCustom for max limit for label and identifier. I have more than 1000 row at the movement in a database . I am looking design best practice to implement pickerFieldCustom with large data sub set.
OriginalPostID-252088
Discussion posts and replies are publicly visible
Parents
0
Arun Theja Muthyalu
Certified Lead Developer
over 8 years ago
Below points might improve the performance while dealing with large DataSubSet;
1. In the 'suggestFunction' a condition something like 'Hit DB only if the character count in the search string is greater than or equal to a fixed number' (say 3). This reduces the number of records that return from DB as it uses more characters to match. When the character count is less than 3, return an empty array and include a message something like 'Type in atleast 3 character to search' for 'instructions' attribute of the picker field.
2. Indexing the column in DB which is used to compare might improve the performance.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
monikab900
A Score Level 1
over 6 years ago
in reply to
Arun Theja Muthyalu
is there is an option access the search string in pickerfieldcustom
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
monikab900
A Score Level 1
over 6 years ago
in reply to
Arun Theja Muthyalu
is there is an option access the search string in pickerfieldcustom
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data