On 8/19/2015 10:37 AM, Matt Olson wrote:
Commitment control is always a good thing. IMHO journaling should be turned on for most production items. If not I know you're not doing commitment control, and that is a bad thing. If you fire off a 10 step process and step #9 fails, don't you want all your updates to data from steps 1 through 8 to roll back in order to not leave your data in shambles? I would think so.

I'm not sure what's being discussed here; it sounds as though step 1:
update inventory for all pending orders, step 2: update backorder status
for all pending orders...step 9: update credit balance for all pending
orders, step 10: mark pending orders 'processed'. That would accumulate
hundreds or thousands of rows in 'commitment pending' status.

I don't do that. Rather, my commitment control deals with one order at
a time. Instead of each 'step' processing a batch of orders, each
'step' is a single business process (subroutine) for a single order. At
any given point during the processing of a single order, I might have a
few dozen rows in 'commit pending'.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.