Re: Serious problem with dbimport
Felix Koshy Mathews wrote:
} Barry Leb wrote:
}
} > <snip>
}
} > memory and 2 cpus. The OS is HPUX 9.04. The disks are the HP versions
}
} <snip>
}
} Hi-Barry,
}
} If your machine have only 2 cpus and you have NUMCPUVPS set to 2, then
} your performance could be affected. That could be the reason why your
} dbimport is taking such a long time. The reason being the overhead for
} managing multiple cpus will be more than what you could get from the 2nd
} cpu after other system/os tasks.
}
Hope you realize that, in above case, setting MULTIPROCESSOR to 0 is
understood. You could even enable SINGLE_CPU_VP, by setting it to 1, which
as Informix claims, could force engine to use optimized code and avoid
unwanted mutex-calls.
--
Have a nice day
Felix K. Mathews
mailto:fmathews@systems.dhl.com