On Wed, 2010-03-17 at 12:07 -0500, Neil Aggarwal wrote: > > There are a few things we do: > 1. When we place an order, we commit the order to the database in > a transaction. > 2. In a separate transaction, we reduce the qty available of the > product by the amounts ordered. This transaction may be > a conflict with other transactions. That is OK. > 3. The inventory management system keeps the master inventory > of the products. We have a continuous job that pulls the > latest updates to the inventory and feeds those updates > back to the web database. > > So, even if an inventory number is wrong for a short time, it will > be updated to an accurate number soon. -- I am just curious is this a hack around some specific problem? It just does not merge in my head. John