upsert is taking long time

srinivas.g · Post by **srinivas.g** » Wed Apr 27, 2011 12:13 pm

In my target i used upsert option. for 50000 records it tooks 10 minutes.
but the same job i designed in server and it took 2 minutes.
The design of the job is :

oracle --> transformer ..> oracle

Please suggest why parallel is taking more time

ray.wurlod · Post by **ray.wurlod** » Wed Apr 27, 2011 3:09 pm

Probably something to do with the multiple nodes contending with each other. Does your partitioning guarantee that each key value can occur on only one node?

Sampath · Post by **Sampath** » Thu Apr 28, 2011 1:19 am

Use loading as sequential method

ray.wurlod · Post by **ray.wurlod** » Thu Apr 28, 2011 1:40 am

What's the point of buying a parallel execution engine then?!!!!

Sampath wrote:Use loading as sequential method

Extremely poor advice, in my opinion.

srinivas.g · Post by **srinivas.g** » Thu Apr 28, 2011 3:57 am

I used hash partiotiong this time job aborted.

Operator terminated abnormally: received signal SIGSEGV