Virtual Agent Reference choice User Input

[Sunit Amin]

We have a requirement in Virtual Agent where the bot provides a prompt to select Employees from the User(sys_user) table.

I created Reference Choice Input action in VA Topic and added conditions for an active employee on the User table.

We are able to fetch accurate results but it takes 3 minutes to return the result.

Is there a way I can improve the response time to fetch the result?

Total records in User table: nearing 2 lakh

Total Active employees: 80K

In the catalog item or agent portal, there is no slowness on the User field prompt.

[Chris D]

Mine looks pretty similar to Mark's - also 4 years old 😛 - maybe slightly less robust, but I do include the flexibility to ask an additional question for relevant topics; that is, if I'm reporting an issue, I could report it for myself or on somebody else's behalf, but if I'm setting a delegate, I'm obviously not going to set myself as the delegate - the second input determines this 🙂  

For reference, these are my inputs and their default values:

• Intro: To search for a person, enter their last name or email address.
  *this lets me customize per topic, i.e. "To search for a delegate..." 
• Include VA User: no
  *this was before they introduced boolean inputs 🙂
• Requested For Question: Is this request for you or somebody else?
  *this is the question that appears if Include VA User != no