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
Attachments
Pasted image.png |
Screenshot 2023-10-16 104347.png |