|
Yes, but we have almost 50 shipping doors, which means almost 50 shipping requests may be done at any given time (so there could be 5,000 records being changed at once). Also, our system is very heavily taxed with interactive jobs (which is why I am petitioning the senior management for a new AS/400, as our box usually hovers at or above 70% CPU usage at any given time), so this may also be a contributing factor. That, coupled with less than optimal source code... Brian. -----Original Message----- From: Rich Duzenbury [mailto:rduz-midrange@xxxxxxxxxxxxxxxxxxx] Sent: Wednesday, December 14, 2005 2:47 PM To: RPG programming on the AS400 / iSeries Subject: RE: Updating a Program using SETLL/READPE - Suggestions On Wed, 2005-12-14 at 14:18 -0500, Brian Piotrowski wrote: > I thank you all for the insight and great suggestions. > > One question to which I did want to respond was with regards to the > number of records that are updated. The answer is: it's variable. It > could be as many as 100, or less than ten. It all depends on what is > being shipped at the time. > Didn't you say it was taking five minutes in some cases? I would not expect anything near that type of response unless someone is holding open a record lock on one of the records that you are trying to update. Ten records or a hundred should be 'lickity-split' (a technical term). Regards, Rich
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.