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 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:
get Selection-Criteria for partno = 1 to number of part-files phantom: SELECT partfile_partno [Selection-Criteria]; savelist [tempname]-[partno] next partno wait for all phantoms to finish merge all savedlists into active select list
You get the idea.
It could be implemented as verbs, SELDISTRIB & SSELDISTRIB. Or even just intercept SELECT and SSELECT, but simply executing the real thing if it finds the file is not distributed.
Of course, the same amount of data needs to be traversed and digested, so this actually (slightly) increases total consumption of system resources due to the additional overhead. Possible i/o & even cpu contention.
What was your experience?
Thank-you for the sage advice, Chuck Stevenson ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
