Page 1 of 1
Inter Process Row Buffering
Posted: Fri Dec 09, 2005 3:12 am
by Rangs
I have a windows 2000 server with more than one processor. Now turning inter-processsor row buffering on can there be true utilisation of multi-processors ie. multiple processes running parallely ??
Posted: Fri Dec 09, 2005 3:35 am
by ArndW
Rangs,
yes. With a multprocessor windows machine even one program may span processeing time across the processors using multi-threading; but that is limited by many factors. When you specify multiprocess in a DataStage job you will have more than one Windows process running, and those can be active simultaneously on different CPUs. Your CPU utilization will go up and processing speed will increase - unless you are absolutely I/O bound, in which case the improvement will be not as noticeable.