APT_CombinedOperatorController is taking more time to execut

babubino · Post by **babubino** » Fri Feb 27, 2009 6:02 am

I have two different instances for a job in the same server.
For one instance
"APT_CombinedOperatorController,0: Operator completed. status: APT_StatusOk elapsed: 0.00 user: 0.00 sys: 0.00 (total CPU: 0.00)" it is taking 1 minute for execution,
whereas for other instance
"APT_CombinedOperatorController(0),0: Operator completed. status: APT_StatusOk elapsed: 273.47 user: 7.17 sys: 0.88 suser: 0.02 ssys: 1.29 (total CPU: 9.36)" it is taking 35 minutes for execution.

Can anybody let us know what is APT_CombinedOperatorController, why is the time difference between the two instances, and how can we tune this ?

bart12872 · Post by **bart12872** » Fri Feb 27, 2009 6:17 am

APT_CombinedOperatorController group two or more process in an unique operator.

Does your two instance of the job treats a similar number of rows ?

Martin.

babubino · Post by **babubino** » Mon Mar 02, 2009 1:20 am

Hi Martin,

The number of rows for the instance which takes more amount of time is around 11,00,000 and for other instance 9,00,000

Binoop

bart12872 wrote:APT_CombinedOperatorController group two or more process in an unique operator.

Does your two instance of the job treats a similar number of rows ?

Martin.