II_NUM_PROCESSORS

In article <4sc1oo$7hv@morgana.netcom.net.uk> veltror@netcomuk.co.uk writes:
>Can anyone tell me for sure what effect not setting
>II_NUM_OF_PROCESSORS correctly does?
>
>
>

This value is used to tune the spinlocking strategy.  Spinning for a lock
makes no sense on a uniprocessor, because the other process needs to run
in order to release the lock.  The code only cares whether the value is
1 or "more than one", so setting a value of two on an eight processor box
will work just as well as the correct value.  Setting it to two on a single
cpu box will cause ingres to waste CPU cycles, and setting it to one on a
multi-cpu box will disable lock spinning, causing minor performance
degradation and extra context switching.

Tony.
--
Tony Sweeney, Level II support	| Life is like a pebble,
1201 Marina Village Parkway,	| on a shingle shore;
Alameda, CA 94501   (510)	| Just the same as yesterday,
sweeney@ingres.com 748 3247	| and the day before.
Ingres Q & A
To William's Home Page
Email William