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 a Web Service

Enabling Result Set Caching for a Web Service

To use cached results for identical web service requests, 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, click the web service, and then click the operation to configure the cache expiration period in the web service operation properties. If you want the Data Integration Service to cache the results by user, enable WS-Security in the web service properties.
  4. To disable result set caching for a web service request when the web service operation is configured to cache the result set, include the following syntax in the HTTP header of the SOAP request:
    WebServiceOptions.disableResultSetCache=true

0 COMMENTS

We’d like to hear from you!