Re: To scale or to be correct: that is the question

[Evan Ireland]

James Cook wrote:
>
> ... I don't think verified updates works in all concurrency situations,
> but it will handle most of them.

One case where it falls down is where some of the columns don't allow easy
tests for equality in the WHERE clause (e.g. some BLOB and similar column types).
Timestamps or version numbers are often more useful (and faster).
________________________________________________________________________________

Evan Ireland              Sybase EAServer Engineering        [EMAIL PROTECTED]
                            Wellington, New Zealand               +64 4 934-5856

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".