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?
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 DBAReceived on Mon Jun 27 2005 - 12:20:27 CDT