Page 1 of 1
Improve Performance
Posted: Wed Aug 18, 2010 5:08 am
by srinivas.g
Source I am having 600000 records and want to load the all records in to(with out transformations) Target table. Job took 22 minutes.
Pelase suggest how to improve the performance. (Simple load source to target). Already target Table having more then 10 milion records and Primary key constraints but no indexes defined.
Posted: Wed Aug 18, 2010 5:20 am
by behrouz
mybe by increasing your buffer,
Arash.
Posted: Wed Aug 18, 2010 6:07 am
by chulett
With so little to go on... perhaps switch to a bulk load.
Posted: Wed Aug 18, 2010 10:59 am
by priyadarshikunal
chulett wrote:perhaps switch to a bulk load.
Bulk load in parallel?
@srinivas.g
need to know which database and what stage is being used to write to it.
Posted: Wed Aug 18, 2010 11:34 am
by chulett
priyadarshikunal wrote:chulett wrote:perhaps switch to a bulk load.
Bulk load in parallel?
Sure, why not? Worst case, run it on one node, it may still be faster. There's far too little information in the original post to get better answers, so hopefully they'll pony up what you've asked for and whatever else might be helpful.
Posted: Wed Aug 18, 2010 11:29 pm
by keshav0307
What database? how many nodes?
Posted: Mon Aug 23, 2010 4:45 am
by srinivas.g
Oracle Database,6 nodes .........