[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Database values changing during a job


> 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
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.