Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: A question about update and insert/delete

Re: A question about update and insert/delete

From: Tom Dyess <tdyess_at_dysr.com>
Date: Fri, 4 Feb 2005 08:37:26 -0500
Message-ID: <wUKMd.13005$3W3.2018@bignews4.bellsouth.net>


"Amardeep Verma" <addverma_at_gmail.com> wrote in message news:431a4ee7.0502040203.1294d80a_at_posting.google.com...
> Hi,
> We have a piece of JAVA code, which does heavy Insert or update.
>
> We have found out that a single update with a single WHERE clause
> (the table is indexed according to the Column given in where clause),
> takes more time compared to a DELETE + INSERT statement.
>
> Can someone please shed light on this? Therotically speaking,
> both the operations(INSERT & DELETE) should take roughly the same
> amount of time.
>
> Let us say that INSERT+DELETE operation takes 10 seconds, than
> update takes 20-30 seconds. We are using bulk updates, using
> Statement.addBatch() statements.
> The Database is Oracle 9i
> _________________________________
> Regards,
> Amardeep Verma

Are you running any update triggers? Do you have some actual times?

-- 
Tom Dyess
OraclePower.com 
Received on Fri Feb 04 2005 - 07:37:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US