5.9.4 Materialized View Performance Considerations
When you design Data Worksheets and Viewsheets (dashboards) to be used with materialized views, keep the following points in mind:
• In the Data Worksheet, try to keep the design as simple as possible.
• In the Data Worksheet, if you are joining or concatenating tables, try to place any parameterized filtering conditions (i.e., conditions that change in response to user input or the runtime environment) on the resultant Data Block rather than on the base tables. Conditions that are placed on base tables may necessitate the creation of a “sub-materialized view” corresponding to each base table and require additional post-processing of these sub-materialized views.
• In the Viewsheet, try to place selection (filtering) components such as Selection List and Range Slider on the resultant Data Block of the Data Worksheet (i.e., the final Data Block resulting from join or concatenation operations) rather than on the base tables.
• In the Viewsheet, try to avoid creating tables that display large numbers of records (i.e., long, scrolling tables).
• If you wish to add a fixed filter condition (i.e., a condition that does not change in response to user input or the runtime environment), implement the fixed condition in the Data Worksheet rather than in the Viewsheet.
See Transformations and Faults for an approach to addressing other common impediments to effective materialization.
See Also
Transformations and Faults, for more information about designing Worksheets to facilitate materialization.
| << 5.9.3 Data Security with Materialized Views | © 1996-2013 InetSoft Technology Corporation (v11.5) | 5.9.5 Transformations and Faults >> |