SAP Knowledge Base Article - Public

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


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):


SAP Datasphere


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


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


SAP Datasphere all versions


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