Poor performance Sequential file to Oracle table

RPhani · Post by **RPhani** » Wed Jul 24, 2013 4:45 am

Hi Experts,

I am facing a performance issue.
In my Job the Source is Sequential file and Target is Oracle Connector. The job has 2 Lookups and 2 Transformers in the Job design.

In QA:Job fetches records from source sequential file in 450 rows/sec

In Production:The same Job fetches records from source sequential file in 25 rows/sec

Nodes, number of source records are same in both situations.

How can I speed it up in Production.
Why it's fetching speed is low?

Thanks in advance,
Phani

arunkumarmm · Post by **arunkumarmm** » Wed Jul 24, 2013 5:57 am

Did you check the server load in your production environment? Are there other jobs running at the same time, using more memory which might be affecting this job's performance?

ArndW · Post by **ArndW** » Wed Jul 24, 2013 6:05 am

Change your output stage to a PEEK stage and compare performance between the environments. I am willing to bet that the difference is in your database writes.