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

"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