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

Home -> Community -> Usenet -> c.d.o.server -> Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 27 Jun 2005 19:20:27 +0200
Message-ID: <m9d0c11nokdbqtau5ukkakglbcffb84n90@4ax.com>


On Mon, 27 Jun 2005 17:00:36 +0100, bugbear <bugbear_at_trim_papermule.co.uk_trim> wrote:

>Because our App is (in reality) doing OLTP. Inserts are
>normally done (and comitted) one at a time.

The ordinary stupidity, obviously.
Single record commits will kill performance.

--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Jun 27 2005 - 12:20:27 CDT

Original text of this message

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