Page 1 of 1

Is it different running between Designer and Director ?

Posted: Sun Jan 25, 2004 11:59 pm
by snow99
In the same PX Job a using the Designer is faster than a using the Director.
The job is loading into Oracle with a Orace stage.
I tried to it a few times and had same results.

If you know, Please tell me why

Won

Posted: Mon Jan 26, 2004 12:40 am
by ray.wurlod
Was it a large difference? What are your measures? Rows/second is not a reliable metric. Can you provide elapsed times? Total volume of data? Did you take any steps to eliminate the effects of cache? (For example, the second run will benefit greatly from operating system and disk controller cache).

It can depend also on which view you have open in Director. Log view is perhaps the worst, as it interrupts execution every few seconds to demand an update. (Monitor view is even worse!)