This might be a little off topic but doesn't sybase the database have some
built in support for optimistic locking?
-----Original Message-----
From: Evan Ireland [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 9:40 PM
To: [EMAIL PROTECTED]
Subject: Re: To scale or to be correct: that is the question
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".
===========================================================================
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".
