<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=695083020-17052006>Hey! I agree too, Ken. I use Qtp for almost
all of my data extract stuff because it is SO much more powerful and convenient
to create a subfile in Qtp than Quiz. Especially true if you have to do
any sort of data manipulation / totalling, etc.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=695083020-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=695083020-17052006>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ken Langendock
[mailto:Ken@Langendock.com]<BR><B>Sent:</B> Wednesday, May 17, 2006 3:27
PM<BR><B>To:</B> Guy Werry; powerh-l@lists.sowder.com<BR><B>Subject:</B> RE:
Distributing the load across SORTWORK files<BR><BR></FONT></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff size=2>I
agree with Guy</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff size=2>When
I wrote the sales system for Carling O'Keefe, we were sorting millions of
records and we reduced the report job from 24 hours to under 20 minutes by
using the SORT command at the OS level on a Vax.</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff size=2>To
sort the subfile at the OS level we had to exit QUIZ or QTP between executes,
but it was well worth the effort.</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff size=2>On
the other hand, I still say extract all your data in QTP using Cursors and
output phase reads and use QUIZ as a DUMB subfile reporting tool will
definitely improve the performance of an application and still be portable
from one platform to another..</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff size=2>A
combination of the two would be the ultimate approach.</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2>Ken</FONT></SPAN></DIV>
<DIV><SPAN class=422042220-17052006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
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>Guy Werry<BR><B>Sent:</B> May 17, 2006 3:35 PM<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: Distributing the load across
SORTWORK files<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006>John,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=835292919-17052006>My
world is Hp-Ux and before that MPE-ix, but I think the advice would still
apply.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=835292919-17052006>The
ideal way to do something like this is to write to and INDEXED SUBFILE, which
has the index in the order that you require.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=835292919-17052006>That
way the records are "inserted" (written) in the order of the index. A
quiz report can then just read the resulting subfile without having to do the
sort at all. Yes, the process that creates the subfile is slow, but the
report is very fast and the overall load on the system is
less.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006>Failing that, if you don't have indexed subfiles
available I would seriously consider putting another file definition into the
dictionary.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006>Other than that, a system sort utility would be a
good idea.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=835292919-17052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=835292919-17052006>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining
& Smelting Co., Limited. </FONT></P></SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf Of
</B>John Stires<BR><B>Sent:</B> Wednesday, May 17, 2006 2:01
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Distributing
the load across SORTWORK files<BR><BR></FONT></DIV>
<DIV>We are doing a very large sort in quiz. It consistently runs for
a time and then dies. We have 10 SORTWORK files defined,
but only one seems to be used. It grows to several million blocks
before the process dies. The others are virtually
untouched.</DIV>
<DIV> </DIV>
<DIV>We are running OpenVMS V6.2 with PowerHouse version 7.10E6.</DIV>
<DIV> </DIV>
<DIV>Does anyone have a suggestion on how to distribute the sort load across
multiple SORTWORK files.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thanks in advance for any help any of you can offer on this.</DIV>
<DIV> </DIV>
<DIV>John Stires</DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>