Performance Tuning Guide

10.5.7
- 10.5.8
- 10.5.6
- 10.5

Back Next

SQL Data Service Result Set Cache Properties

To increase performance, you can configure the result set cache properties for a Data Integration Service. You can also configure the number of milliseconds that the result set cache is available to use for a SQL data service.

The following table describes the result set cache properties for the Data Integration Service:

Property	Description
File Name Prefix	The prefix for the names of all result set cache files stored on disk. Default is RSCACHE.
Enable Encryption	Indicates whether result set cache files are encrypted using 128-bit AES encryption. Valid values are true or false. Default is true.

The following table describes the property that configure the number of miliseconds that the result set cache is available to the SQL data service:

Property	Description
Result Set Cache Expiration Period	The number of milliseconds that the result set cache is available for use. If set to -1, the cache never expires. If set to 0, result set caching is disabled. Changes to the expiration period do not apply to existing caches. If you want all caches to use the same expiration period, purge the result set cache after you change the expiration period. Default is 0.

Rename Saved Search

Table of Contents

Performance Tuning Guide

Performance Tuning Guide

SQL Data Service Result Set Cache Properties

SQL Data Service Result Set Cache Properties