Re: Logical Files vs. Physical Keys

[Bob_J_Wellhoefer@xxxxxxxxxxxxxxxxxx]

Well, let me add a **constructive** comment to this discourse.

Copying keyed files is still slower, but there is a workaround to it. If
you specify the FRMRCDS as 1 and the TORCDS as 999999999, (or whatever the
max. is, 2,147,483,646, I think, ) copying is done by RRN, and it is as if
copying a file with no keys at all. So keying a file does not pose a speed
disadvantage with CPYF if you copy by RRN.

regards,
bob






"brian" <brian@cannonexpress.com>@midrange.com on 03/23/2000 12:40:46 PM

Please respond to MIDRANGE-L@midrange.com

Sent by:  owner-midrange-l@midrange.com


To:   <MIDRANGE-L@midrange.com>
cc:
Subject:  Re: Logical Files vs. Physical Keys


From: Mike Cunningham <MCUNNING@pct.edu>
> I don't know if it's still a fact but 10 years ago when we set our
> standards an unkeyed PF would copy 1,000 times faster than an unkeyed PF
> when it came time to add a field and copy the old PF to the new.

Heh.  Unkeyed vs. unkeyed?

+---
| 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
+---