Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MASSIVE degradation of insert using sequence ID's via JDBC on 9i?
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