LDAP Integration - In the current application that we are building, we are integ

harishn over 8 years ago

LDAP Integration - In the current application that we are building, we are integrating to organizations LDAP. The LDAP has around 40,000 users. All of these users are not present in Appian.
For user pickers: We created custom users pickers that directly query LDAP based on at minimum 3 characters entered by users. But due to the huge list of users, it is taking a lot of time - about 20 secs - for each search to return back from LDAP? Any suggestions on how to fasten this search?
Another Option that we tried was to have the whole list of LDAP users downloaded to MS SQL DB and query from there. However, we did not get any better results. Plus we faced issues in querying the full user list from LDAP and getting it into DB? Any suggestions on this? Thanks a lot in advance.

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 8 years ago

40k lines in a DB should not take that long. Did you define an index on the queried column. What data do you return, how many fields? Try to reduce that. Show only 15 matching users in the picker select box. We have a custom picker that fecthes data from MySQL. Is about 30k lines. The DB query itself takes about 80 ms.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

40k lines in a DB should not take that long. Did you define an index on the queried column. What data do you return, how many fields? Try to reduce that. Show only 15 matching users in the picker select box. We have a custom picker that fecthes data from MySQL. Is about 30k lines. The DB query itself takes about 80 ms.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data