Home » SQL & PL/SQL » SQL & PL/SQL » Merge performance
Merge performance [message #275145] Thu, 18 October 2007 08:57 Go to next message
mucki
Messages: 3
Registered: April 2006
Location: Duesseldorf, Germany
Junior Member
Hi,

when i merge a table with 600.000 new entries it takes about 3 to 4 minutes on a SATA, one CPU server. I only have text data, no blobs. does it sound somehow reasonable ?

This should be 600.000 inserts with a full table scan on two tables. A sqlldr statement with 600.000 inserts on the same server takes about 17 seconds. OK, a merge writes redo-logs but ...

How long does a merge in your environments run ?

Th@nx in advance,

Mucki
Re: Merge performance [message #276384 is a reply to message #275145] Thu, 25 October 2007 01:22 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Pfew, not an easy question. Your guess is as good as mine. But there's a fair chance that your SQL statement is not optimized. Why MERGE? Why not INSERT? You don't talk about updates. And SQL*Loader is a tool that does one thing: load data. It is designed to do that fast.

MHE
Previous Topic: Build SQL Statement then Execute
Next Topic: DELETION OF DUPLICATE RECORDS
Goto Forum:
  


Current Time: Sat Dec 03 05:41:54 CST 2016

Total time taken to generate the page: 0.09635 seconds