Benchmarking different algorithms (was Beginning/End of week)
David Morrison - Corporate
dmorrison@mcbrideelectric.com
Wed, 10 Nov 2004 07:13:17 -0800
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4C737.CE5ED2AC
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Richard and Blue,
=20
Nice work. There goes my theory! I still prefer the conversion =
technique for clarity, though. =20
=20
Richard, you never upgraded to 6.07F? (from 1998 or 1999?).
=20
Cordially,
=20
Davd Morrison
-----Original Message-----
From: powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of Latimer, Richard
Sent: Tuesday, November 09, 2004 4:31 PM
To: David Morrison - Corporate; powerh-l@lists.sowder.com
Subject: RE: Benchmarking different algorithms (was Beginning/End of =
week)
This has now got my curiosity going ...=20
=20
I have just conducted two back to back tests as follows:
Test 1:
set report limit 100000 =20
access flight_data =20
DEFINE d_days_1st num*6 & =20
=3D DAYS(FLOOR(dte_mov / 100)*100) + 1=20
set subfile name test1out keep =20
rep summary idy_mov dte_mov d_days_1st =20
Test 2:
set report limit 100000 =20
access flight_data =20
DEFINE d_days_1st num*6 & =20
=3Ddays(nconvert(substring(cconvert(dte_mov,8),1,6) + "01"))
set subfile name test2out keep =20
rep summary idy_mov dte_mov d_days_1st =20
=20
Both were compiled and run sequentially in batch mode, no other users =
were active at the time.
Test 1 - elapsed time 1 minute 57 seconds, 109 seconds processing unit =
time reported in log
Test 2 - elapsed time 2 minutes 36 seconds, 151 seconds processing unit =
time reported in log
=20
Test done using 6.07E on AS/400 model 30S
=20
Looks like a win for maths on the IBM ...
=20
cheers
Richard
>=20
--=20
**********************************************************************
This electronic message together with any attachments is confidential. =
If
you receive it in error: (i) you must not use, disclose, copy or retain
it; (ii) please contact the sender immediately by reply email and then
delete the emails. Views expressed in this email may not be those of the
Airways Corporation of New Zealand Limited
**********************************************************************
------_=_NextPart_001_01C4C737.CE5ED2AC
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff =
size=3D2>Richard and=20
Blue,</FONT></SPAN></DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff =
size=3D2>Nice work. =20
There goes my theory! I still prefer the conversion technique for =
clarity,=20
though. </FONT></SPAN></DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff =
size=3D2>Richard, you=20
never upgraded to 6.07F? (from 1998 or 1999?).</FONT></SPAN></DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff=20
size=3D2>Cordially,</FONT></SPAN></DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D546411015-10112004><FONT color=3D#0000ff =
size=3D2>Davd=20
Morrison</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com]<B>On=20
Behalf Of </B>Latimer, Richard<BR><B>Sent:</B> Tuesday, November 09, =
2004 4:31=20
PM<BR><B>To:</B> David Morrison - Corporate;=20
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Benchmarking =
different=20
algorithms (was Beginning/End of week)<BR><BR></FONT></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>This=20
has now got my curiosity going ... </FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004></SPAN> </DIV>
<DIV><SPAN class=3D440231000-10112004></SPAN><SPAN=20
class=3D440231000-10112004><FONT face=3DArial color=3D#0000ff =
size=3D2>I have just=20
conducted two back to back tests as follows:</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><STRONG>Test 1:</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>set=20
report limit=20
=
100000 &=
nbsp; =20
<BR>access=20
=
flight_data &n=
bsp; =20
<BR>DEFINE d_days_1st num*6=20
=
& &n=
bsp; =20
<BR> =3D DAYS(FLOOR(dte_mov / 100)*100) + 1 <BR>set =
subfile=20
name test1out =
keep =20
<BR>rep summary idy_mov dte_mov d_days_1st =
<BR></FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><STRONG>Test 2:</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>set=20
report limit=20
=
100000 &=
nbsp; <B=
R>access=20
=
flight_data &n=
bsp; &nb=
sp; &nbs=
p; =20
<BR>DEFINE d_days_1st num*6=20
=
& &n=
bsp; &nb=
sp; =20
<BR> =3Ddays(nconvert(substring(cconvert(dte_mov,8),1,6) + =
"01"))<BR>set subfile name test2out=20
=
keep &nb=
sp; &nbs=
p; =20
<BR>rep summary idy_mov dte_mov=20
=
d_days_1st &nb=
sp; </FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Both were compiled and run sequentially =
in batch mode,=20
no other users were active at the time.</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>Test=20
1 - elapsed time 1 minute 57 seconds, 109 seconds processing unit =
time=20
reported in log</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>Test=20
2 - elapsed time 2 minutes 36 seconds, 151 seconds processing =
unit time=20
reported in log</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff size=3D2>Test=20
done using 6.07E on AS/400 model 30S</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Looks like a win for maths on the IBM ...</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>cheers</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>Richard</DIV>
<DIV><BR> </FONT></SPAN><FONT face=3D"Courier New" =
size=3D2>></FONT>=20
</DIV><FONT size=3D3><BR><BR>--=20
=
<BR>*********************************************************************=
*<BR>This=20
electronic message together with any attachments is confidential. =
If<BR>you=20
receive it in error: (i) you must not use, disclose, copy or =
retain<BR>it;=20
(ii) please contact the sender immediately by reply email and =
then<BR>delete=20
the emails. Views expressed in this email may not be those of =
the<BR>Airways=20
Corporation of New Zealand=20
=
Limited<BR>**************************************************************=
********<BR></BLOCKQUOTE></FONT></BODY></HTML>
------_=_NextPart_001_01C4C737.CE5ED2AC--