Re: Application locking to support optimisitc locking ?

From: JXStern <JXSternChangeX2R_at_gte.net>
Date: Wed, 18 Oct 2006 17:18:45 GMT
Message-ID: <0eocj2d3n064s1hbudomjd9orsfji43riq@4ax.com>

On 18 Oct 2006 09:46:36 -0700, "Timasmith" <timasmith_at_hotmail.com> wrote:

>Of course this adds considerations. This process needs to be
>efficient. Inserting and deleting rows would not be efficient -
>perhaps only updating rows in the lock table is the way to go -
>activate, inactivate etc. Purge now and then through a batch job.

What is your volume and rate?

A couple of inserts/deletes per second on average, should be harmless, unless you have very, very bursty peaks that might have problems.

J. Received on Wed Oct 18 2006 - 12:18:45 CDT