/tpu question

[Richard Witkopp]

> 1$ conv/fdl=<newfdl> <data.sf> <trial.tmp> [/nosort if sf in 
> primary key order]
> 2$ anal/rm/fdl <trial.tmp>
> 3$ edit/fdl/nointeractive/gran=double/anal=<trialfdl> <trialfdl>
> 4$ delete <trial.tmp;>
> 5$ conv/fdl=<trialfdl> <data.sf> <data.dat> [/nosort if sf in 
> primary key order]
> 
> This will result in a well-tuned file, with all indices 
> optimally loaded.
> You should put the trial data file on a disk with the same 
> cluster factor as
> the data disk, otherwise the bucket sizes picked may be inappropriate.

Picking nits here, but editing/nointeractive makes some assumptions
that don't necessarily result in the best-tuned files. Much better
than the Powerhouse default (which assumes you will never add a record),
but you can generally better tune files manually with a little knowledge
of RMS and how your apps work.
 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.