Hi
I have three jobs which loads the data in oracle database.The jobs are simple with only two stage jobs ,the first stage extracts the data from sybase using sybase ocpx stage and loads it into database using ODBC enterprise stage ,I have set the array size to 10000 and isolation level to read commit.
The first two jobs which have feilds only in char or varchar run which runs with a speed of 9000 rows per sec (approx) .while in the last job I have integer ,timestamp and decimal feilds and the job runs with a speed of 1550 rows per sec.
Why is there a difference in performance .,or something can be done to improve it
Thanks
Arif
ODBC Performance
Moderators: chulett, rschirm, roy
If by any change, this is true reason on datatype, theoritically, I would guess, it might be due the timestamp avaialability.
Timestamp may need to be converted into internal value of datastage while processing and converting back to the original value.
Timestamp may need to be converted into internal value of datastage while processing and converting back to the original value.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: ODBC Performance
This is another bug that Ascential fixed.
Case: 437994, Ecase: 76017
Case: 437994, Ecase: 76017