Distributing the load across SORTWORK files

[Heasman, David]

  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.
 
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.
 
 
Dave H
 

	-----Original Message-----
	From:
powerh-l-bounces+david.heasman=schroders.com at lists.sowder.com
[mailto:powerh-l-bounces+david.heasman=schroders.com at lists.sowder.com]
On Behalf Of John Stires
	Sent: 17 May 2006 20:01
	To: powerh-l at lists.sowder.com
	Subject: Distributing the load across SORTWORK files
	
	
	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.
	 
	We are running OpenVMS V6.2 with PowerHouse version 7.10E6.
	 
	Does anyone have a suggestion on how to distribute the sort load
across multiple SORTWORK files.
	 
	 
	Thanks in advance for any help any of you can offer on this.
	 
	John Stires

__________________________________________________________________


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 at 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 at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060523/72712083/attachment.htm