Benchmarking different algorithms (was Beginning/End of week)
Latimer, Richard
richard.latimer@airways.co.nz
Wed, 10 Nov 2004 13:30:43 +1300
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4C6BC.83460754
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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_01C4C6BC.83460754
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial color=3D#0000ff si=
ze=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 class=3D440231000-101120=
04><FONT=20
face=3DArial color=3D#0000ff size=3D2>I have just conducted two back to bac=
k tests as=20
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 si=
ze=3D2>set=20
report limit=20
100000 &nb=
sp; =20
<BR>access=20
flight_data &nbs=
p; =20
<BR>DEFINE d_days_1st num*6=20
& &nbs=
p; =20
<BR> =3D DAYS(FLOOR(dte_mov / 100)*100) + 1 <BR>set subfil=
e name=20
test1out keep <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 si=
ze=3D2>set=20
report limit=20
100000 &nb=
sp; <BR>ac=
cess=20
flight_data &nbs=
p; &=
nbsp; &nbs=
p; =20
<BR>DEFINE d_days_1st num*6=20
& &nbs=
p; &=
nbsp; =20
<BR> =3Ddays(nconvert(substring(cconvert(dte_mov,8),1,6) +=20
"01"))<BR>set subfile name test2out=20
keep  =
; &n=
bsp;=20
<BR>rep summary idy_mov dte_mov=20
d_days_1st  =
; </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 mo=
de, no=20
other users were active at the time.</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial color=3D#0000ff si=
ze=3D2>Test 1=20
- elapsed time 1 minute 57 seconds, 109 seconds processing unit time=
reported in log</FONT></SPAN></DIV>
<DIV><SPAN class=3D440231000-10112004><FONT face=3DArial color=3D#0000ff si=
ze=3D2>Test 2=20
- elapsed time 2 minutes 36 seconds, 151 seconds processing unit time=
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 si=
ze=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 si=
ze=3D2>Looks=20
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>
-- <BR>
**********************************************************************<BR>
This electronic message together with any attachments is confidential. If<B=
R>
you receive it in error: (i) you must not use, disclose, copy or retain<BR>
it; (ii) please contact the sender immediately by reply email and then<BR>
delete the emails. Views expressed in this email may not be those of the<BR>
Airways Corporation of New Zealand Limited<BR>
**********************************************************************<BR>
</FONT>
</BODY></HTML>
=00
------_=_NextPart_001_01C4C6BC.83460754--