Lawrence Bruhmuller wrote:
>
> It is my suspicion that any DB-tier OCC would be *way* faster and more
> efficient that an app-server OCC check.
> ... [lots of good stuff deleted]
Your suspicion is only valid if the cost of executing a statement like:
update myTable set myCol = 123, ts = 4 where myKey = 456 and ts = 3
is *way* more than the cost of executing a statement like:
update myTable set myCol = 123 where myKey = 456
(Version/counter columns are only one form of OCC that can be used by an app
server, but in general the use of OCC by the app server should have a similar
execution cost).
________________________________________________________________________________
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".
