Re: OnLine 7.X performance - R U satisfied?

Mickey Mestel wrote: > my # > or ready threads jumps between 2 and 6, Try for an average of zero > my checkpoints are averaging 1 > - 4 seconcds, things like this. In a later post you mention wide extremes in checkpoint duration. There are at least two known bugs that Informix is addressing. > i have 2 physical cpu's but am running as a single > cpu machine. Be sure to set MULTIPROCESSOR to 0. This will reduce much overhed. Set SINGLE_CPU_VP to 1 for the same reason. Is your SHMVRTSIZE correct? Look at your log file back to when your engine came On-Line and look for shmgets. If any grow the SHMVRTSIZE parm to encompass all these grabs. I have PDQPRIORITY set to 0 which, for a single VCPU engine I suspect is best. Even with 4 HW CPUs and 4 VCPUs Parrallelization did nothing for me. Please post your findings. Enjoy, Bill