SPINCNT advice requested

Posted in 1992

andrew.shaw — 9 Sep 92 16:52:17 GMT — source: Informix-list mailing list archive (1991-1998)

I am running OnLine 4 on a Sun690 with 4 processors. The OnLine documentation suggests using "sunldmod" and setting SPINCNT=1200 in the dbconfig file. I have done this and performance has doubled. The documentation also suggests that while 1200 is "a good starting value", the best value is application-dependent. Can anyone give me some hints as to what this parameter actually does? Is performance supposed to change linearly, or do I have to search the entire space to find the optimum value? Any pointers would be appreciated. Thanks, Andrew Shaw AT&T Bell Labs