<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:p =
"urn:schemas-microsoft-com:office:powerpoint" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s =
"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs =
"urn:schemas-microsoft-com:rowset" xmlns:z = "#RowsetSchema" xmlns:b =
"urn:schemas-microsoft-com:office:publisher" xmlns:ss =
"urn:schemas-microsoft-com:office:spreadsheet" xmlns:c =
"urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc =
"urn:schemas-microsoft-com:office:odc" xmlns:oa =
"urn:schemas-microsoft-com:office:activation" xmlns:html =
"http://www.w3.org/TR/REC-html40" xmlns:q =
"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc =
"http://microsoft.com/officenet/conferencing" XMLNS:D = "DAV:" XMLNS:Repl =
"http://schemas.microsoft.com/repl/" xmlns:mt =
"http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2 =
"http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda =
"http://www.passport.com/NameSpace.xsd" xmlns:ois =
"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir =
"http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds =
"http://www.w3.org/2000/09/xmldsig#" xmlns:dsp =
"http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc =
"http://schemas.microsoft.com/data/udc" xmlns:xsd =
"http://www.w3.org/2001/XMLSchema" xmlns:sub =
"http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec =
"http://www.w3.org/2001/04/xmlenc#" xmlns:sp =
"http://schemas.microsoft.com/sharepoint/" xmlns:sps =
"http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi =
"http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs =
"http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf =
"http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p =
"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf =
"http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss =
"http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi =
"http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi =
"http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver =
"http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels =
"http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp =
"http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t =
"http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m =
"http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl =
"http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl =
"http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService"
XMLNS:Z = "urn:schemas-microsoft-com:" xmlns:st = ""><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812">
<STYLE>@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: r_ansi;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal
}
SPAN.EmailStyle18 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: #1f497d; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-US link=blue vLink=purple>
<DIV dir=ltr align=left><SPAN class=843502119-18082009><FONT color=#0000ff
size=2 face=Arial>Hi Ken,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843502119-18082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843502119-18082009><FONT color=#0000ff
size=2 face=Arial> 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).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=843502119-18082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=843502119-18082009><FONT color=#0000ff
size=2 face=Arial>Dan</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
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 10:12
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Performance
Questions and a little need for some education.<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Unfortunately I have to agree
with your client on the QTP/QUIZ argument. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">QTP is (IMHO) a much smarter
tool to use for “</SPAN>simple, straight forward extracts to create CSV
files<SPAN style="COLOR: #1f497d">”. QTP Allows you to do more with the extracts
than QUIZ. It also gives you more readable statistics to find problems than
QUIZ. QTP allows you to logically break up an extract into REQUESTS, where QUIZ
needs separate programs.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">QUIZ also has/had a problem with
extracting more than 32767 records into a text file (NO HEAD, PAGE LENGTH 0), it
inserted blank lines somewhere in the middle of the file for no reason. After
that I used QTP.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">In short and IMHO, QUIZ is DUMB
and should only be used to report the contents of a
subfile.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">As for the TEMP/DEFINE issue, I
agree with you.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">I think the assumption that
DEFINES are slower than TEMPS is a little clouded. A straight DEFINE vs. a
similar program than uses TEMPS is not going to give you any major
benefit.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">If you have cascading DEFINES or
DEFINES that are referenced multiple times, then TEMPS would be a performance
improvement as the DEFINE is re-evaluated every time it is referenced and the
TEMP is only evaluated once per record complex.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">BUT. If you incorporate OUTPUT
PHASE READS and TEMPS, and/or TEMPS with an AT statement…then you start leaving
QUIZ and DEFINES far behind.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">By OUTPUT PHASE READING all
files that are NOT required in the record complex (like Client Names, Address
Types, etc), your record complex is much smaller and therefore much
faster.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Of course if you had the option
of an SQL database, then you can move the ACCESS statement into a CURSOR and
retrieve only the columns you want, everything increases
exponentially.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Just my two cents worth. I’ve
been doing this for a few years now and stick to what I have proven works best.
I did the same benchmarks back in the late 80’s and found quiz was faster at
dumping a file, but most programs never stay that way. Sooner or later someone
wants more in “that” report, so I always start out calling my quiz-only programs
??R01B.QZS just in case I need to add a QTP extract in front of it down the
road.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d">Ken<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: #1f497d"><o:p> </o:p></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=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+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On
Behalf Of </B>John Stires<BR><B>Sent:</B> August 18, 2009 9:46 AM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> [Bulk] Performance Questions and a
little need for some education.<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I have always been under the understanding that, in general,
you use TEMP ITEMs in QTP rather than DEFINEs. The client where I am
currently working needs some convincing and is willing for me to run a bench
test. They use QTP heavily for doing simple, straight forward
extracts to create CSV files. I have strongly suggested that QUIZ would be
a much better tool or, at least use TEMPs instead of DEFINEs.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>I took one of their production extract QTP programs with
loads of DEFINES and converted them all to TEMP ITEMs. This is the only
difference. The original does not have as many cascading DEFINEs as most
of their programs so this is an even better test in comparing the performance of
DEFINES vs. TEMPs and then vs. QUIZ to create the same output
file.<o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal>I ran my test programs numerous times manually on the
development machine and got execution times pretty much as I
expected.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Records
Processed
DEFINEs
TEMPs
QUIZ<o:p></o:p></P>
<P class=MsoNormal>123,800
0:0:54
0:00:53
0:00:45<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Then I put them into a COM file and ran them with a SHOW TIME
before and after the programs.<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Records
Processed
DEFINEs
TEMPs
QUIZ<o:p></o:p></P>
<P class=MsoNormal>123,800
0:0:53
0:00:53
0:00:45<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Then I took these three COM files to their production machine
and got totally unexpected results:<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>Records
Processed
DEFINEs
TEMPs
QUIZ<o:p></o:p></P>
<P
class=MsoNormal>158,802
0:00:53
0:01:01
0:00:57<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<P class=MsoNormal>The development machine is an ALPHA running <SPAN
style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">OpenVMS V8.3 with PowerHouse
version 8.40.D running against RMS files..<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">The
production machine is a Titanium running the same version of VMS and
PowerHouse.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt">Can
someone explain to me how DEFINES can actually run faster the TEMPs and even a
comparable QUIZ program? This kind of shakes my long standing belief
system in how QTP works.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: r_ansi; FONT-SIZE: 10pt"><o:p> </o:p></SPAN></P>
<P class=MsoNormal>Thanks,<o:p></o:p></P>
<P class=MsoNormal>John Stires<o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P></DIV></BODY></HTML>