5.9 Materialized Views
Materialized views are available only for Viewsheets.
A materialized view is a caching strategy that optionally pre-aggregates and stores the data required by a Viewsheet so that the Viewsheet can respond more quickly at runtime. When a materialized view exists for a Viewsheet, the Style Intelligence engine attempts to query the cached materialized view rather than querying the database. This can significantly reduce the run time for certain queries.
Viewsheets that possess a materialized view will rely on this materialized view to supply their data. For Viewsheets which do not possess a materialized view, behavior is specified by the 'Performance' options described in Performance Options and Safeguards. For Visual Composer's design mode, you can specify whether a Viewsheet without materialized view should execute queries to retrieve data from the database or alternatively utilize meta-data for faster performance. For runtime execution of a Viewsheet without materialized view, you can specify whether the Viewsheet should execute queries to retrieve data from the database or alternatively generate an error. (See Performance Options and Safeguards for more information.)
To improve performance, you can also distribute a materialized view across multiple machines. See Distributing Materialized Views (Data Grid) for further details.
See Also
Performance Options and Safeguards, for other materialized view settings.
| << 5.8.4 Auditing Asset Dependencies | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.9.1 Creating a Materialized View >> |