Having an interesting discussion with our C# developers over best method to insert/update new orders to our system. No current journaling on the 11 tables updated for a new order.
We have had instances of "partial updates" in our testing.
The failed updates could be time-outs, user cancelling session (after long delay), or logic halt in client (they are working on identifying those).
These are customer entered orders, not employee entered, and network issues can be a factor.
There are couple tables that hold the "working order" until submit.
I have suggested update through stored procedure, so all the final updates are code running on the i.
Committment control has been mentioned as well, but seen as a much larger effort to implement.
This would be many hundreds of orders per day.
Jim Franz
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.