25.3 Improving Performance in Large Scale Reviews

Based on your data, reviews can take significant time and effort and occasionally may need to be terminated and restarted. To improve performance, administrators can either temporarily disable review statistics calculations or enable materialized view. Both of these options should be used with caution.

Disabling review statistics calculations

You can disable review statistics calculations with the property. iac.update.stats.review.disabled. Contact your SaaS Operations Administrator to disable the setting and if you want to enable the setting again.

Using materialized view/specialized tables

A materialized view is a snapshot of an instance of time which is used to optimize performance in large scale reviews. Materialized views are supported in Postgres and Oracle environments. When this view is enabled, you can cache user, account, permission, and role names to improve rendering time of review items by selecting Monitor Reviews > Cache review item names in a review definition. In MSSQL environment similar capabilities are implemented using specialized tables.

You can use the setting add-property GLOBAL iac.review.display.materializedViews.enabled to enable materialized view. Contact your SaaS Operations Administrator to enable the setting.

Once materialized view is enabled, the search and sort features will use the values at the time the materialized view was either created or last refreshed. As by definition, a materialized view is a snapshot, the data can become stale and out of sync with the catalog, and your search might not yield accurate results. You can refresh the snapshot data at any time by selecting More to expand review instance header, and then clicking Refresh. Also, you can Enable or Disable the caching of review item names for that review instance.