RE: Sorting large file

With sufficient main storage (ideally the whole file should fit in there)
FMTDTA is probably closer the metal than index operations. The difference is
FMTDTA reads the file into the main storage and runs the sort with no I/O
involved during the sort itself except for the paging I/O, and it can be
minimized if enough main storage is available. But CPYF means significant
I/O workload for the duration of the whole COPY process. Of course, it's a
trade-off and decision very much depends on what is more likely to be the
bottleneck, disk I/O or memory.

Lo

> -----Original Message-----
> From: Al Barsa, Jr. [SMTP:barsa2@ibm.net]
> Sent: Thursday, October 05, 2000 7:50 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      Re: Sorting large file
> 
> At 04:19 PM 10/4/00 -0500, you wrote:
> > > At 02:11 PM 10/4/00 -0500, you wrote:
> > > >Folks,
> > > >
> > > >I have a sequential file of 10,000,000 80-character text records.
> > > >How do I sort the file the most efficiently?
> > > You could copy it to a file that it one giant key.  I would suggest a
> > > mother @#$%er system with a lot of main storage and disk arms.
> > >
> >
> >Anything better? That solution will take a long time...
> >
> >COBOL experts on the list? SORT verb in COBOL?
> 
> 
> Agreed, but a system index runs as close to the metal as you can get.  I 
> don't think that any HLL will outperform it.
> 
> Al
> 
> 
> 
> 
> 
> >+---
> >| This is the Midrange System Mailing List!
> >| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner/operator:
> david@midrange.com
> >+---
> 
> 
> 
> +--------------------------------------------------+
> | Please do not send private mail to this address. |
> | Private mail should go to barsa@ibm.net.         |
> +--------------------------------------------------+
> 
> Al Barsa, Jr. - Account for Midrange-L
> Barsa Consulting Group, LLC.  
> 400 > 390
> 
> Phone:                914-251-1234
> Fax:          914-251-9406
> http://www.barsaconsulting.com
> http://www.taatool.com
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---