Informix 5.10

Posted in 2006

henryg — Mon, 24 Jul 2006 17:59:31 GMT — source: Usenet: comp.databases.informix

Hi, Can anyone tell me whether Informix 5.10 will benefit (or be able to use) multiple CPU's. I can't seem to find a Multiprocessor parameter for tbconfig. Thanks in Advance, Henry

↪ replying to henryg

Art S. Kagel — Mon, 24 Jul 2006 15:27:34 -0400 — source: Usenet: comp.databases.informix

henryg wrote: > Hi, > > Can anyone tell me whether Informix 5.10 will benefit (or be able to use) > multiple CPU's. > I can't seem to find a Multiprocessor parameter for tbconfig. Informix OnLine (OL 4.xx, & 5.xx) is single threaded. The only parallel processing it is capable of is parallel sorting if the PSORT_NPROCS and PSORT_DBTEMP environment variables are set then index builds and larger ORDER BY clauses will be broken into $PSORT_NPROCS streams of data and an sqlturbo process will be started to sort each stream. Then primary sqlturbo then merges the sorted streams that result and return the data to you. However, each sqlturbo process is single threaded and except for parallel sorting each connection gets only one sqlturbo process. For true parallel query and multithreading you have to upgrade to Informix Dynamic Server (IDS 7.xx, 9.xx, 10.xx). Art S. Kagel