Hi,
When I worked with sequensial file I have tried 'No of Readers per Node' option to make the extraction process faster.But the result I have got is just against .
Following are result of my trails.
Start Time - Production Run Time (in Sec) - No of Nodes
Never use anything less than a couple of minutes runtime for any timing comparison purposes! Your startup-time accounts for almost all your activity, so of course using more readers is going to add significantly to your times.
Don't even think about using multiple processes before your runtime goes over 5 or 10 minutes; it will just cause more overall system load and make your server run slower. This means that even though you might get your job to run in 30 seconds instead of 60 seconds the system will need to work 3 times as hard so your overall performance has gone down - unless you are not running in a multiuser/multijob environment.
Arnd - The sample shows the increase in elapse time of Runtime. Shouldnt it get shorter.
arun@sinmax - If you have large volume of data to run, pls do it and produce the result, which will be optimal to analyze.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'