Indexing
When your lookup query (source or target) is based on a table with more than 10,000 records then it is highly recommended that at least one of the fields in the query is indexed in order to improve performance and reduce the risk of timeouts occurring.
Null Parameter Action Value
If it is often the case where a query should return no value due to a value on the current source/target record that is included in the query being NULL, consider using the Null Parameter action to prevent the query running at all for these records.
Consider the following example. A source query is run to obtain the name of the Incident Assignee, using the following query on the User form:
[Sys_id]=#Assignee#
However, it is known that the assignee on the source record is empty for the majority of the records, and if it is NULL, the query should always return NULL. Hence there is no need to run the query at all in these cases - the query only needs to be run when a source assignee is set.
In this situation, setting the NULL Parameter Action to 'Set NULL' makes sense, and prevents unnecessary calls to the source server to perform lookups that will return no results anyway.
Comments
0 comments
Please sign in to leave a comment.