Re: User space, outfile or workfile

[Scott Klement <klemscot@xxxxxxxxxxxx>]

> Can anybody tell me which would be the fastest of the 3?
>
> I know I could code the 3 versions and run performance tests, but I'd hate
> to hear someone say later on: 'Oh, but I could have told you in advance
> that xxx would be much faster.'

I'm assuming that you won't need to access the data by key?  (I can't
think of a reason that you would!)  Therefore, user space access will be
faster than file access -- no reason to make a temp file in QTEMP.

Personally, I think I would load the relevant bits of the user space into
an array of qualified data structures.   An array in main storage will run
slightly faster than user space will (very slightly) but will be much
easier to read and work with. Since you'll be looping the array for every
record in the file, you might as well have something that's easy to work
with :)