Data services performance optimization

[Former Member]

Hi Friends,

I am new to Data service  working on the project there we are spacing the performance issue.

For ten million record with basic query transform along with case and validation transform, its took exactly 6 hrs and 30 minutes.

Can you please suggest me how to improve the performance??

[severin_thelen]

Hello Dliph,

there are several ways to improve performance.

1. Parallelization of Dataflows (you can do this in the DF options)
2. DF/WF Design: connected DFs/WFs working sequential, not connected DFs/WFs working paralel
3. Pushdown: DB do the main work

For details please visit the following links:

SAP BODS advanced Optimization & error handling techniques.

Furthermore there is an optimization guide.

Regards

Severin