SAP Knowledge Base Article - Public

3389372 - Slow performance of Data Flow fetching mass data from SAC with default Fetch Size

Symptom

Data Flow runtime has a poor performance.

Slow performance fetching mass data from SAC (SAP Analytics Cloud) with default fetch size.

Using the default fetch size for reading larger amounts of data can be 10 and more times slower (Control Fetch Size is switched off):

Environment

SAP Datasphere

Resolution

Using Batch Size parameter, increase the fetch size drastically to the maximum of 99.999 records

See Also

SAP Help Portal Add or Create a Target Table

Keywords

slow, poor, hanging, long runtime, execution, duration, reducing, CDI, Cloud Data Integration, SAC, SAP analytics Cloud , KBA , CA-DI-EMB , Data Intelligence Embedded in Data Warehouse Cloud , DS-DI-DF , Data Flows , How To

Product

SAP Datasphere all versions

Attachments

Screenshot 2023-10-16 104347.png
Pasted image.png