lookupCacheUpdatePeriod in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

The amount of time the lookup data is cached in the server. Change it to a higher value if your lookup data is not going to change in real time frequently. Keep a higher value as it would improve the performance as the cache refresh is reduced.

samCacheUpdatePeriod in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

The amount of time the data about Security Access Manager (SAM) roles (no users) is cached in the server. Change it to a higher value if your role data is not going to change in real time very frequently. Keeping a higher value improves the performance, as the cache refresh is reduced.

threadSchedulerIdleTime in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Time interval of the daemon thread that checks and triggers the Lookup cache and the Security Access Manager cache operations based on their update period. That is, every 5 seconds, the daemon thread would check and trigger the lookup cache and Security Access Manager cache if their update period is reached.

This period can be increased to improve performance, if it is not necessary to check the SAM and Lookup Cache time periods every 5 seconds.

serverPageSize in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Number of records to be retrieved from the Hub Server when a search operation is performed. Note that even though Hub Server shows 10 records per page, internally it loads these many numbers of records (given by this parameter). And the Hub Server caches the remaining records that are not shown in the view.

A higher value could make the search results performance better, provided the Hub Server can handle the load and cache.

maxSearchResultsExportedRows in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Number of rows that are exported when using the export option in the search results page. Do not increase the value unless there is a valid use case. The greater the value, the lower will be the performance of the export operation.

This property is found in the

cmxserver.properties

file.

If set to true, users can enable the case insensitiveness attribute for individual columns in the base object, to enable case insensitive query search in

Data Director

. Enabling this flag would incur a new index created for such columns. As index management has its own performance overhead, use this flag with caution.

isEffectiveDateIncluded in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

By default, effective date is automatically populated with current date. This may impact performance for normal queries that do not need effective date. In such scenarios, you can set this flag to false to remove the default value.

For more information, search the

Informatica Knowledge Base

for article number 347953.

Default is true.

This property is found in the

cmxserver.properties

file.

By default,

Data Director

filters the duplicate results from the search query that joins child records. However, this flag if enabled, can affect the performance depending on the time it takes to de-duplicate the search results. If duplicates are not an issue in the search result, you can disable this flag.

For more information, search the

Informatica Knowledge Base

for article number 122829.

asyncChildLoading in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

If true, all child records are opened (expanded) automatically when you open a parent subject area.

This property is found in the

cmxserver.properties

file.

This number denotes the maximum number of relationships that are to be shown in Relationship Flyover in

Data Director

. Internally, the best version of the truth (BVT) calculation is done for all such relationships. Therefore, having a high number here would impact the performance of relationship flyover.

For more information, search the

Informatica Knowledge Base

for article number 157628.

hmInactiveRelationshipsAvailable in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

If true, Hierarchy Manager in the

Data Director

would show all the inactive relationship records also. Do not keep this value as true unless there is a valid use case to do so.

maxParallelPromoteThreads in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Default is 1.

Determines the maximum number of parallel threads when a task is approved (Promote API).

This is helpful when you promote parent, child, and grandchild subject areas together.

maxParallelBvtThreads in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Default is 1.

Determines the maximum number of parallel threads when a task is viewed (PreviewBVT API).

This property is found in the

cmxserver.properties

file.

Maximum number of tasks assigned to each user when automatic task assignment is enabled. Keeping this a high number would impact the performance of task context screens in

Data Director

.

For more information, search the

Informatica Knowledge Base

for article number 134833.

maxImportThreads in

CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL

Default is 5.

Maximum number of threads to be used while using the Bulk Import module.

PUT user exits are called for each and every record individually.

Having a complex logic in the PUT user exit would deteriorate the performance. Use user exit with caution.

This property is found in the

cmxserver.properties

file.

Applicable for SearchQuery, SearchHMQuery, GetOneHop, and GetEntityGraph SIF APIs (also the relevant

Data Director

modules) when effective dates are specified.

searchQuery.buildBvtTemp.MaxRowCount

: Specifies the maximum number of records to be used in the BVT calculation when processing a search operation with effective date filters.

sif.search.result.query.temptableTimeToLive.seconds

: Specifies the number of seconds, the temporary table of the specific API must reside in the server. That is, the earlier mentioned APIs would store the full results in its own temporary tables which are cleaned-up automatically based on this timeout. Pagination would work based on the data from this temporary table instead of re-querying the API repeatedly from the core tables. For search operations involving larger number of records, it is recommended to increase this timeout value.

Example:

If a hierarchy entity can have more than 10,000 related records, set the values as shown:

For more information, see the

Multidomain MDM Configuration Guide

and the

Multidomain MDM Services Integration Framework Guide

.

This property is found in the

cmxserver.properties

file.

Specifies if

Data Director

server traffic compression is enabled.

For more information, see the

Multidomain MDM Configuration Guide

.

Available in

cmxcleanse.properties

.

Configures the thread count for the SearchMatch API.

Optimal value can be decided based on your environment. You may need to test with an incremental value of thread count until you see an optimal performance.