BusinessObjects Board

SAP BODS performance

dataservices performance
#1

Hi,

We have execution results for few DFs and wanted to check whether it is a good or bad performance.

Environment:
Source DB: DB2
Target DB: Teradata
Transformation: none, 1:1 mapping
BODS machine configuration: SAP BODS 4.0 with 4 CPU and 8 GB RAM
Other: used teradata bulk loading - Fastload with generic pipes. tried DOP but did not improve performance much

Results:
3.2 Million records processed in 4 minutes
67 Million records processed in 76 minutes
97 Million records processed in 107 minutes

Wanted to check if this is optimal performance by BODS or we can further improve on it.

ankur_s2000 (BOB member since 2006-06-08)

#2

It may be better for you to run some standard tests instead. See here.

Darth Services :uk: (BOB member since 2007-11-20)