Has anyone written a utility to split out selects for distributed files,
1 phantom for each partfile, then pin the results into 1 select or saved
list?
The purpose would be to decrease total elapsed time for a given select
on the big type30 file.
Was it worth it?
In pseudo-code, something like:
Haven't tried it
but my guess is that unless you spread out the partfiles on several
physical disk units it will actually take longer time due to excess
access arm movements ...
( Or that the files are quite small and fits in very few cylinders )
-- mats
Stevenson, Charles wrote:
Has anyone
snip
Has anyone written a utility to split out selects for distributed files,
1 phantom for each partfile, then pin the results into 1 select or saved
list?
/snip
I've done something along these lines. Seperate paragraphs do their selects,
then I simply use the EDitor to concatenate the files
@listserver.u2ug.org
Subject: Re: [U2] [UV] Distributed SELECTs for distributed (Type30) files
Date: Tue, 22 Mar 2005 19:42:58 -0500
Hopefully Dan F can add more, and provide better information than I am able
to
remember.
There was some claims processing programs that utilized this, or some
similar technique