Overview
Standard view maintenance includes managing its performance settings to minimise latency. For each view, you can set options regarding duplicate records, caching, optimization and much more. These are described in detail on this page.
The Performance Settings dialog box contains all the performance settings for a view.
The table below describes each of these settings.
Setting | Description |
---|---|
Default Cache Period | The Default Cache Period is a setting for all reports that are based on the view. This field dictates how long to store queried data in a cache so it may be reused by multiple report users. If the data in your source system is not time sensitive, you can set the cache time to be high and limit the impact of report users on the source system. The data is stored in a SQL data cache for the duration of the time you enter here. This setting is entirely independent of the view's cache settings. |
View Row Limit | Set the maximum number of rows to be returned for any report written from this view. You can adjust this up or down depending on how long it takes for the rows to be returned. |
Optimize View | When enabled, the report SQL that Yellowfin generates will include only the tables that are being used within the report, or are set to Mandatory. When toggled off, the report SQL that Yellowfin generates will include every table added to the view. |
Filter text suggestions | When enabled, this lets certain field types use the Filter Text Suggestions functionality with User Prompt filters. See Field Settings for more information. |
Auto Refresh | When enabled, this option sets the Auto Refresh function in the Report Builder to be on by default. |
Show Duplicate Records In New Reports | This option sets the default for a similar toggle in the Report Builder for any new reports. When enabled, this option sets the default for new reports created from this view to show duplicate records (ie, the Report Builder toggle is also enabled). When toggled off, this option sets the default for new reports created from this view to hide duplicate records (ie, the Report Builder toggle is toggled off). Note: Toggling this option won’t affect existing reports, and the setting can also be overridden at the Report Builder level for each report. |