[ic] Database values changing during a job

Grant emailgrant at gmail.com
Fri Nov 3 20:21:14 EST 2006


> > 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.

Will do, thanks Peter.

- Grant


More information about the interchange-users mailing list