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
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: