Database Reference
In-Depth Information
Eliminating the session bottleneck
If you do not have source, target, or mapping bottlenecks, you can make session properties
check for bottlenecks.
Optimizing the commit interval
The commit interval is the number of records after which Integration Service commits the
data into the target. Selecting an appropriate commit interval will help in enhancing the
performance. If you select the commit interval as a low value, it will make Integration Ser-
vice commit data more times, which will hamper the performance.
The buffer memory
When you run the workflow, Integration Service needs to allocate blocks of memory to
hold the data at various stages of processing, including caches if required. Make sure that
you have sufficient buffer memory available for the processing, else Integration Service
fails the process because of lack of memory.
Performance data
Session properties allow you to store the performance-related details to the repository. If
you select to save the performance details, Integration Service writes the log to the reposit-
ory. This will consume processing time. Make sure that you are not checking the option if
you do not need to save the performance details.
