cancel
Showing results for 
Search instead for 
Did you mean: 

Data services performance optimization

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hello,

Here are some tips for optimization.

Please go through the below link.

It might be helpful.

Thanks,

Monika

former_member18162
Active Participant
0 Kudos

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
0 Kudos

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
Contributor
0 Kudos

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