[ic] Database values changing during a job
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.
More information about the interchange-users