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??

[Former Member]

Hello,

Here are some tips for optimization.

Please go through the below link.

It might be helpful.

Thanks,

Monika

[former_member18162]

Hello,

For your reference, the Data Services Performance Optimization Guide, mentioned by Severin, can be found here:

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_perf_opt_en.pdf

Cheers!
Julie

[Former Member]

Hi Severin,

Thanks for quick reply.

Actually performance issue is not in the data store level.

Even i changed the DOP in the DF level, its takes same time

While i checked in the Monitor option in job execution logs, "ROUND_ROBIN_SPLIT" taking too much of time to load ten million records

[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