When using a filter text into the select box nothing happens for 10-20 seconds. Then the result appears. After that it is fast enough.
There are fields, where we have to select an item from these tables, and the select query is against a very large table.
Release : 17.3
Component : CA SERVICE CATALOG
Any computation of the report variable parameter forces a full load of the table; instead this should use a straight passing of it, using the form
$({'val': _val})
This then lets the query optimize at the database level, including the use of "top x" in select queries, to deliver greater performance. This form is documented here:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/using/service-catalog-management/manage-forms/perform-automated-tasks-in-form-fields/use-javascript-functions-in-fields.html