Alan McDonald wrote:

> for stock levels, always insert 1 for increment and -1 for decrement.
> housekeeping is a procedure which groups the sum of stocktype and replaces
> the starting balance with the value and deleting the increments and
> decrements. Then your system continues with inserting 1 and -1 again

Is it really needed if all the applications use snapshot transaction mode?

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org