on 05-19-2015 6:45 AM
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??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Dliph,
there are several ways to improve performance.
For details please visit the following links:
SAP BODS advanced Optimization & error handling techniques.
Furthermore there is an optimization guide.
Regards
Severin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.