HI,
I want to know that Oracle database table updating thru server 7.5 text file (Around 10 lakh records) is taking 1hrs 10minutes while same file updating thru PX 7.5 is taking only 16 minutes.
I want to know that why PX updating is fast against server.
Regards
Vikas Gupta
DS 7.5 server to DS 7.5 PX
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
PX jobs are faster than server jobs when writing to most databases - that is why IBM wants customers to move to the parallel platform. There are two things making it faster 1) the new Database connectors are much faster than the old Server Job database stages. 2) parallelism can provide massive improvements in database read and write times.
I ran some performance tests a few years ago and found that even if you remove the parallelism from DataStage jobs and run them on a single node they still perform many times faster than Server jobs:
http://it.toolbox.com/blogs/infosphere/ ... stats-6976
You are seeing a massive improvement and you probably haven't even tuned that job yet.
I ran some performance tests a few years ago and found that even if you remove the parallelism from DataStage jobs and run them on a single node they still perform many times faster than Server jobs:
http://it.toolbox.com/blogs/infosphere/ ... stats-6976
You are seeing a massive improvement and you probably haven't even tuned that job yet.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn