Re: Chaining with a very large file

[Peter.Colpaert@xxxxxxxxx]

Douglas,

If by 'chain' you mean retrieving 1 single record having a unique key, you 
can't beat the performance (I think) of using a keyed logical and native 
I/O.

As always, YMMV.

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



"Douglas W. Palme" <dpalme@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/02/2006 15:08
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG Group" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Chaining with a very large file






we may be faced with having to allow an interactive program to do a chain 
to 
a very large file; one with approximately 1.1 billion records and a file 
size of approximately 9.7gb of disk space.

Are there any performance issues that I should take into consideration? 
Should I consider breaking the data down into multiple files? 

The file will have a total of three numeric fields, all packed, 5 digits 
for 
the first two and 4 digits for the third.

Suggestions, thoughts, helpful hints.....would all be appreciated.


If you bought it, it was hauled by a truck - somewhere, sometime.