Re: 2 CPU VP's

Juan R. Guzman wrote: > I have a Sparc 20 with 2 processors with Solaris 2.4 and Online 7.11UC1. I have > been thinking of incrementing the amount of CPU VP's from one to two. I don't > use the server for anything else other that for the Informix application. Any > feedback from who has played with this before. I experimented with combinations of fragmented and non-fragmented tables, setting the PDQ, and the number of CPU VP's when I first set Online 7.10.UC2 on my AT&T 3431 (dual 90MHz Pentium) running AT&T MP-RAS Unix. I don't know if my benchmark (loading a table from a flat file) is typical, but this is copied & pasted from my notes: >>>With a 500-record cursor, one fragment, two cpu vp's. real 5:58.3 user 40.0 sys 5.1 So it looks like simple is best! One last time: With a 500-record cursor, one fragment, one cpu vp real 5:34.7 user 38.3 sys 6.1 <<< I seem to recall that there are platform-dependent features that can significantly affect CPU VP performance, so absolutely read the manual early and often... -- Alexander J. Oss Computer Systems Manager Films for the Humanities & Sciences