Skip to Content
avatar image
Former Member

Data services performance optimization

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • May 19, 2015 at 08:43 AM

    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.

    Let the database do the hard work! Better performance in SAP Data Services thanks to full SQL-Pushdown

    Furthermore there is an optimization guide.

    Regards

    Severin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 19, 2015 at 12:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2015 at 11:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 27, 2015 at 09:24 AM

    Hello,

    Here are some tips for optimization.

    Please go through the below link.

    It might be helpful.

    Some tips for fine tuning the BODS job for faster and efficient executions with optimal resource utilizations.

    Thanks,

    Monika

    Add comment
    10|10000 characters needed characters exceeded