Improve Performance

srinivas.g · Post by **srinivas.g** » Wed Aug 18, 2010 5:08 am

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.

behrouz · Post by **behrouz** » Wed Aug 18, 2010 5:20 am

mybe by increasing your buffer,
Arash.

chulett · Post by **chulett** » Wed Aug 18, 2010 6:07 am

With so little to go on... perhaps switch to a bulk load.

priyadarshikunal · Post by **priyadarshikunal** » Wed Aug 18, 2010 10:59 am

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.

chulett · Post by **chulett** » Wed Aug 18, 2010 11:34 am

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.

keshav0307 · Post by **keshav0307** » Wed Aug 18, 2010 11:29 pm

What database? how many nodes?

srinivas.g · Post by **srinivas.g** » Mon Aug 23, 2010 4:45 am

Oracle Database,6 nodes .........