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

Use Multiple CPUs

Use Multiple CPUs

Increasing the number of processing threads increases the load on the nodes that run mappings. If the nodes contain ample CPU bandwidth, concurrently processing rows of data in a mapping can optimize mapping performance.
The Data Integration Service can use multiple CPUs to process a mapping that contains multiple partitions. The number of CPUs that the service uses depends on factors such as the number of partition points, the number of threads created for each pipeline stage, and the amount of resources required to process the mapping. A simple mapping runs faster in two partitions, but typically requires twice the amount of CPU than when the mapping runs in a single partition.

0 COMMENTS

We’d like to hear from you!