<DATAVIEW_OPTIMIZE>
= optional in PARAM
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C | Value in col D | Occurrence in PARAM sheet | Comment | |
---|---|---|---|---|---|---|
FORM | REPORT | |||||
<DATAVIEW_ID> | TRUE/FALSE | n/a | 1 time for each data view | Important: Only applicable to v1 templates (new data engine). If this parameter is TRUE, the data view queries will be optimized by first creating an xcache table. |
If the template executes numerous queries against the data view (expand or fixed rows), you can use this parameter to gain performance to optimize the data view. Once you specify that a data view should be optimized, Bizview creates an xcache table with the data the report/form will need and all queries will run against the xcache table instead of the data view table.
For more information, see Table Optimizer.
Access Data View Optimize from the right panel in Template Design by selecting Parameters > Data Retrieve > Data View Optimize.
In the right panel, a grid with all data views used in the template will be visible. In the grid, you can define if any of the data views should be optimized by setting the value to TRUE.
Note: You only need to optimize the data view if the template executes a large number of queries against the data view. For example, if you have numerous expand or fixed rows in the template. If not, there is no need to optimize the data view.