Re: Logical Files vs. Physical Keys

["Mike Cunningham" <MCUNNING@xxxxxxx>]

Makes sense on the surface but I believe you will find that indexing a
100,000 record file with a CRTLF command is much faster than creating a
index as each of 100,000 records is added to a file. The
index-everything-at-once way is much faster than the
index-one-record-at-a-time way. Of course your CPU and memory use go way
up on the CRTLF but total time getting done is less.

>>> Gwecnal@aol.com 03/24/00 02:30PM >>>
In a message dated 00-03-23 13:32:18 EST, MCUNNING@pct.edu writes:

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

Well, then you have to create the logical that gives you keyed access.
I 
believe that if you add in the time it takes to create the logical, it
is 
near enough a wash.  (I assume you did not mean unkeyed to 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
+---