performace issue with updating a huge number of records
Posted: Wed Oct 15, 2008 2:12 am
I create a job for update records in a table. the job is design like this:
DataSet----->Join(Inner)<----Oracle(Read)
|
|
|
Oracle(Update)
if the dataset and oracle(read) don't have so many records, the update speed is ok. but if the Oracle(Read) output about 200 thousand records and the DataSet also output about 200 thousand, the update will last for more than 20 hours. but in actual environment, the oracle(Read) will output more than 10 million records.
could someone give some suggestions to improve the performance?
DataSet----->Join(Inner)<----Oracle(Read)
|
|
|
Oracle(Update)
if the dataset and oracle(read) don't have so many records, the update speed is ok. but if the Oracle(Read) output about 200 thousand records and the DataSet also output about 200 thousand, the update will last for more than 20 hours. but in actual environment, the oracle(Read) will output more than 10 million records.
could someone give some suggestions to improve the performance?