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: <xhoster_at_gmail.com>
Date: 28 Jun 2005 16:57:49 GMT
Message-ID: <20050628125749.681$xG@newsreader.com>


"sybrandb_at_yahoo.com" <sybrandb_at_yahoo.com> wrote:
> Unless the user has a coffee break after every individual update, I
> frankly don't see why you should commit every update.
> Do you think changing one bit in a database constitutes a transaction?

It certainly can be.

> I don't! A transaction is a *logical unit of work*. Changing one record
> is not necessarily a logical unit, in fact whether it is a logical unit
> should be determined by the end-user, NOT by the application.

Since when are business rules determined by the end user? Usually the end user doesn't even know what a RDB is, let alone ACID.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB
Received on Tue Jun 28 2005 - 11:57:49 CDT

Original text of this message

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