Slowness for Lookup to CMDB

[Swapnilc191]

Hi,
I had a task as the user should be able to request for making an update to a CI.
I have a catalog with 3 variables for this: (var1) Name of the CI Class, (var2) Name of the CI and (var3) Detailed description of what needs to be updated.

The var 2 will auto-populate the value based on the CI Class selected in var1. Now, both var1 and var2 are lookup to cmdb_ci table.

Issue - When I click on catalog on the portal, it takes more than 30 secs to open it and once it is open I select var1, and it takes again 20+ secs to auto-populate var2.

The reference qualifier for var2 used is - 'javascript:'sys_class_name=' +current.variables.what_device_class_the_device_belong_to+"^ref_cmdb_ci_hardware.hardware_statusNOT INretired,stolen"'
And variable attribute is - 'ref_qual_elements=what_device_class_the_device_belong_to'

How to make this smooth (remove slowness)?

[Brad Bowman]

When you say var 1 and var2 are lookup, do you mean variable types of lookup select box?  If so, that - combined with the number of records in your cmdb_ci table is your issue.  You can try removing the ^ref_cmdb_ci... to the end to see if that speeds it up.  If that is the culprit there might be a better way to accomplish that same part of the filter, but generally lookup variable types will never be as fast/smooth as reference types.