RE: Slow respond time when file change to open with update&Add

[rob@xxxxxxxxx]

And thank you for responding back with your results.

I think performance can be increased on a lot of things if we stick to the 
rule, but handle the exceptions, instead of program all the exceptions but 
allow the rule.  For example, instead of checking if a date is valid when 
converting from a number to a date field, just do it, but wrap it with a 
MONITOR.  Oh well, at least these people catch the errors instead of 
letting the program blow sky high.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Lim Hock-Chai" <Lim.Hock-Chai@xxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/29/2004 01:05 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Slow respond time when file change to open with update&Add






After copied those data to our test system, here is the result.

1) Ran for 33 mins (420 secs of processing unit time): Input file opened 
as (IF K), Outfile (UF A).  (Chain, update if found else write)
2) Ran for 9 mins ( 365 secs of processing unit time): Input file opened 
as (IF  ), outfile (UF A) Unique.  (Chain and update if write failed)
3) Ran for 7 mins ( 307 secs of processing unit time): Input file opened 
as (IF  ), outfile (O   ). (Write only)


Seems like the unique key method does help.

Thanks everybody.


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Haas, Matt
Sent: Wednesday, April 28, 2004 4:50 PM

Another variation on this is to create a unique key on the output file and 
always write to it. When the write fails with a duplicate, you can do your 
chain and update. If you're doing mostly adds, this should speed things 
up. If you're doing mainly updates, this will probably be slower since 
it's adding another I/O operation on updates.

Matt

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.