RE: Date arithmetic - performance dog?

40% compared to what?  I had this problem too.  In the end I reached two
conclusions:  Do the filtering first.  Don't do date stuff on a record that
you will then immediately skip because the zip code isn't in the group you
want.  Second, genearlly the date seemed to perform badly until I did the
same work in the old ways.  
That was evem worse! :)
 
 
---------------------------------------------------------
Booth Martin   http://www.MartinVT.com
Booth@xxxxxxxxxxxx
---------------------------------------------------------
 
-------Original Message-------
 
From: RPG programming on the AS400 / iSeries
Date: Thursday, May 15, 2003 7:34:17 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Date arithmetic - performance dog?
 
I've been curious about this as well. I have an EDI translator program that
does heavy date manipulation. Granted it reads thru 3 million records on
average, but it takes about 3-4 hours. I know a lot has to do with how we
prioritize our jobs around here, but since someone mentioned they thought
they took a 40% performance hit when using date fields and date logic, I've
been wondering.
 
 
 
-----Original Message-----
From: Mlpolutta@xxxxxxx [mailto:Mlpolutta@xxxxxxx]
Sent: Wednesday, May 14, 2003 9:26 AM
To: RPG programming on the AS400 / iSeries
Subject: Date arithmetic - performance dog?
 
 
I wanted to see if you folks have found that ADDDUR and SUBDUR (etc.), and
MOVEing to/from date fields are REALLY poor performers - it sure seems that
way to me. Is there a way to make such things perform well?
 
TIA,
Michael

.