[ic] Database values changing during a job

Peter peter at pajamian.dhs.org
Wed Nov 1 22:28:29 EST 2006


On 11/01/2006 05:52 PM, Grant wrote:
> A total rewrite of my inventory allocation system has the job
> executing in 40 seconds instead of 20 minutes.  Kind of embarrassing
> really.  Anyway, how does table locking work in the context of IC?  If
> I lock a table for 40 seconds, how are read and write requests handles
> during the locked period?  Will they fail, or will they be queued
> until the table is unlocked?

It should wait (and queue up), however look into transactions for what
could be a better way of doing what you want.

Peter



More information about the interchange-users mailing list