Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Target Optimization
  4. Source Optimization
  5. Transformation Optimization
  6. Mapping Optimization
  7. Partitioned Mapping Optimization
  8. Run-time Optimization
  9. SQL Data Service Optimization
  10. Web Service Optimization
  11. Connections Optimization
  12. Data Transformation Optimization

Performance Tuning Guide

Performance Tuning Guide

Enabling Result Set Caching for an SQL Data Service

Enabling Result Set Caching for an SQL Data Service

To use cached results for identical SQL data service queries, configure the Data Integration Service to use result set caching.
  1. In the Administrator tool, select a Data Integration Service.
  2. Click the
    Process
    view to configure the result set cache properties.
  3. Click the
    Application
    view and then click the SQL data service to configure the Result Set Cache Expiration property.

0 COMMENTS

We’d like to hear from you!