Re: multithread in INFORMIX, how?

I have heard repeatedly that on machines with two CPU's The performance actually degrades if you have 2 or more cpu VP's. So you are o.k with one CPU vp running and setting MULTIPROCESSOR parameter to false. Informix engine starting from version 6.x is a multi-threaded engine. If you do "onstat -g ath" you will see all the threads that are running on different Informix processes. <<<Saeed>>> In <501bcs$sej@cssun.mathcs.emory.edu> billy@west.co.za (Billy Wheeler) writes: > >> We are using Informix V.7 aand dual cpu HP machine. We have 700 stored >> procedures currently stay on database server, and we still using single thread. >> We are thinking using multithread to increase performance, can anyone there >> can show us how to do it? Is this so called PDQ? > >You can't switch multithreading on, it's always on. You might be confusing MT >with parallel processing. > >The reason why you may only be accessing one ONINIT is because your OnLine >config might have SINGLE_CPU_VP = 1 or NUM_CPU_VPS = 1. But parallel processing >only really takes off after 3 CPUs (although it could improve performance >with fewer CPUs). > >HTH. > >-- >Ciao, > >Billy > >+--------------------------------------------------------------------- --------+ >| Billy Wheeler Junior Programmer / Director The West Solutions Group | >+--------------------------------------------------------------------- --------+ >| (E) billy@west.co.za (U) http://www.west.co.za/billy.html | >+--------------------------------------------------------------------- --------+ >| A WAY COMPUTERS CHANGED THE WORLD: 1 million banking errors | >+--------------------------------------------------------------------- --------+