<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
</style>
</head>
<body class='hmmessage'>
<BR> Hi All:<BR>
<BR>
If you really need to do large sorts you can improve your performance by <BR>
writing to a subfile and then doing a VMS sort over which you have more control.<BR>
<BR>
This issue has come up on this list before.<BR>
Check out <A href="http://lists.sowder.com/pipermail/powerh-l/1998-April/000247.html">http://lists.sowder.com/pipermail/powerh-l/1998-April/000247.html</A><BR>
<BR>
Regards,<BR>
Peter<BR>
<HR id=stopSpelling>
From: ken.langendock@rogers.com<BR>To: powerh-l@lists.sowder.com<BR>Subject: RE: Performance Questions and a little need for some education. -Output Phase reading<BR>Date: Wed, 19 Aug 2009 10:54:32 -0400<BR><BR>
<STYLE>
.ExternalClass .EC_shape
{;}
</STYLE>
<STYLE>
.ExternalClass p.EC_MsoNormal, .ExternalClass li.EC_MsoNormal, .ExternalClass div.EC_MsoNormal
{margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.ExternalClass a:link, .ExternalClass span.EC_MsoHyperlink
{color:blue;text-decoration:underline;}
.ExternalClass a:visited, .ExternalClass span.EC_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
.ExternalClass span.EC_EmailStyle17
{font-family:'Calibri','sans-serif';color:windowtext;}
.ExternalClass span.EC_EmailStyle18
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass span.EC_EmailStyle19
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass span.EC_EmailStyle20
{font-family:'Calibri','sans-serif';color:#1F497D;}
.ExternalClass .EC_MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;}
.ExternalClass div.EC_Section1
{page:Section1;}
</STYLE>
<DIV class=EC_Section1>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Ah sorry, that still counts as a file in the file counter…</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Speed is the biggest improvement. Clean code is just a benefit of doing it this way.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">BTW, I didn’t come up with it all by myself. I used to work at Cognos for a brief period of time in the Toronto office a loooooooonnnnnnggggg time ago and a brilliant programmer by the name of Doug Blackmore showed me how to do this. He was in my opinion one of the top 3 PH programmers in the world at that time. I think he is still there, but they moved him into pre-sales…what a waste.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Ken</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=EC_MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> Dan Lambshead [mailto:dlambshe@milk.org] <BR><B>Sent:</B> August 18, 2009 4:36 PM<BR><B>To:</B> Ken@Langendock.com; powerh-l@lists.sowder.com<BR><B>Subject:</B> [Bulk] RE: Performance Questions and a little need for some education. -Output Phase reading</SPAN></P></DIV></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt">Hi Ken,</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt"> Yes, that is exactly what I've seen! I would say it makes the code more readable, by simplifying the Access statement, and it also reduces the record complex so could improve performance. Beyond that I am trying to remember if there are any more advantages (perhaps for one, if you're reaching the no of files limit, it doesn't count).</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt">Dan</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P>
<DIV style="TEXT-ALIGN: center" class=EC_MsoNormal align=center><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt">
<HR align=center SIZE=2 width="100%">
</SPAN></DIV>
<P style="MARGIN-BOTTOM: 12pt" class=EC_MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> powerh-l-bounces+dlambshe=milk.org@lists.sowder.com [mailto:powerh-l-bounces+dlambshe=milk.org@lists.sowder.com] <B>On Behalf Of </B>Ken Langendock<BR><B>Sent:</B> Tuesday, August 18, 2009 4:20 PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Performance Questions and a little need for some education. -Output Phase reading</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Yep that is what I meant.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">The advantages:</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">If you relate this to a QUICK screen; you have a Primary file and some detail/secondary files and reference files.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">In QTP the only thing you need to access (via the ACCESS statement are the Primary and/or Secondary/detail files.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">All other files can be read in the OUTPUT PHASE (obviously that rule is subjective depending on the desired record complex).</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">For example:</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">In a screen you could have:</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">FILE Orders PRIMARY</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">FILE OrderDetails DETAIL</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">FILE Products REFERENCE</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Show the order info, detail info and the product description…etc.</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">In QTP you can set the same thing up like this:</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d">ACCESS Orders &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> LINK OrderNumber OF Orders &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> TO OrderNumber &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> IN OrderDetails</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> SORT ON ProductNumber OF OrderDetails &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> ON DateLastOrder OF OrderDetails</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d">OUTPUT Products &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> AT ProductNumber &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> ADD &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> UPDATE &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> NOITEMS &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> IF 1 EQ 2 &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> VIA ProductNumber &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> USING ProductNumber OF OrderDetails</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d">SUBFILE subfile1 &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> KEEP &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> AT ProductNumber &</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> INCLUDE whatever</SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Courier New'; COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d">Ken</SPAN></P>
<P class=EC_MsoNormal><SPAN style="COLOR: #1f497d"> </SPAN></P>
<DIV>
<DIV style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0cm; PADDING-LEFT: 0cm; PADDING-RIGHT: 0cm; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<P class=EC_MsoNormal><B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt">From:</SPAN></B><SPAN style="FONT-FAMILY: 'Tahoma','sans-serif'; FONT-SIZE: 10pt"> Dan Lambshead [mailto:dlambshe@milk.org] <BR><B>Sent:</B> August 18, 2009 3:25 PM<BR><B>To:</B> Ken@Langendock.com; powerh-l@lists.sowder.com<BR><B>Subject:</B> [Bulk] RE: Performance Questions and a little need for some education.</SPAN></P></DIV></DIV>
<P class=EC_MsoNormal> </P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt">Hi Ken,</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt"> Just wondering what you mean by "Output Phase Read". Is that when you do an Output ... if 1 = 2 ... or something like that, so you are only doing a read? I have seen that before, but now am trying to remember what the advantages are (if that's what you're talking about).</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: blue; FONT-SIZE: 10pt">Dan</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=EC_MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"> </SPAN></P></DIV><br /><hr />Stay in the loop and chat with friends, right from your inbox! <a href='http://go.microsoft.com/?linkid=9671349' target='_new'>Learn how!</a></body>
</html>