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: Noons <wizofoz2k_at_yahoo.com.au>
Date: 27 Jun 2005 18:16:09 -0700
Message-ID: <1119921369.912711.320080@o13g2000cwo.googlegroups.com>


Sybrand Bakker wrote:
> 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.
>

Entirely up to you, Sy. But I'd cut Bugsy a little slack. Believe me, I've known him for quite a while and he's anything but dumb. If he says he's got a prob, I for one listen. Received on Mon Jun 27 2005 - 20:16:09 CDT

Original text of this message

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