It is important that you avoid hotspots.
I would maintain an inventory impact table and use triggers to feed that.
Then, I would have a service application that would roll the impact records
into the actual inventory records. This way you have one single process
responsible for keeping the inventory up to date.

I'm sure there are some other kinks but this should give you a few things to
think about.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Gerald W. McCaig" <gwmccaig@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 06, 2002 11:01 AM
Subject: [IBO] Inventory


> Hello anyone,
>
> I am looking for the best way to update inventory quantities using the
> IBO Query. I want to make sure that if the transaction is interrupted
> because the primary query action is canceled that this update to the
> inventory query is also rolled back. I also want to ensure that if
> multiple stations are updating at the same time that the inventory
> quantity is accurate.
>
> Thank you in advance for your help.
>
> Jerry