<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1543" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=009051715-23052006>
13 years ago my System Manager surprised me by saying that the external sort
would be much quicker than a sort in Quiz. I'd been taught that it wasn't, but
exiting Quiz and sorting the subfile reduced elapsed time from 5 hours to 10
minutes.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=009051715-23052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=009051715-23052006>Using
Quiz to produce a subfile on the Vax and then sorting it, you can still use the
initial Dictionary portion of the subfile for the resulting sorted data; you
have to rename it to the new filename and you can then just Access
*sortedsubfile and you're away.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=009051715-23052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=009051715-23052006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=009051715-23052006>Dave
H</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=009051715-23052006></SPAN></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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+david.heasman=schroders.com@lists.sowder.com
[mailto:powerh-l-bounces+david.heasman=schroders.com@lists.sowder.com] <B>On
Behalf Of </B>John Stires<BR><B>Sent:</B> 17 May 2006 20:01<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><pre>__________________________________________________________________
This message might contain confidential information. If it has been sent to you in error please do not forward it or copy it or act upon its contents, but report it to postmaster@schroders.com
Schroders has the right lawfully to record, monitor and inspect messages between its employees and any third party. Your messages shall be subject to such lawful supervision as Schroders deems to be necessary in order to protect its information, its interests and its reputation.
Schroders prohibits and takes steps to prevent its information systems from being used to view, store or forward offensive or discriminatory material. If this message contains such material please report it to abuse@schroders.com
Schroders does not normally accept or offer business instructions via email unless prior agreements are in place. Any action that you might take upon this message might be at your own risk.
Schroder Investment Management Limited
31 Gresham Street
London EC2V 7QA
Authorised and regulated by the Financial Services Authority. Schroder Investment Management Limited is entered on the FSA register under the following register number: 119348
Registered Office
31 Gresham Street
London EC2V 7QA
Registered number 1893220
VAT registration number 243 8687 30
</pre></BODY></HTML>