Loading data to lookup select box is slow

[sandaru]

We have a Lookup select box that contains long list of customer ID s. Due to this one that form takes around 2 minutes to load/refresh it self. Please give me some advice to speedup this process.

PS: We cant use any reference because it has a "onChanged" event in it.

/Sandaru

[ramireddy · Accepted solution]

2 minutes is very slow, I guess you might be loading lakhs of records. Showing these many records in a "select" control will not give good user experience as well.

You can implement "onchange" event for the "reference" type variables as well. You can implement a "catalog client script" -> select catalog item -> onchange event -> select this variable name. Then this event fires, whenever the customer is changed. My suggestion: use Reference variable itself.

[Sanoop1]

Hi Pushpitha,

Ideally in such scenarios the use of lookup select box is not recommended as it will cause a performance overhead every time the form is loaded. But if your requirement doesn't allow otherwise' it is advisable to make use of reference qualifiers to reduce the number records pulled up with every form load. You can refer the links below for creating reference qualifiers:

Reference Qualifiers for Service Catalog Variables - ServiceNow Wiki

PS: Hit correct answer/like/helpful as applicable