Re: 2 or 4 cpu's running Informix OnLine 7.xx

Neal Howard wrote: > > snip.... > > In a two-cpu situation, you want that second (apparently idle) CPU to > be running your users' 4GL apps, which hopefully will be talking to > the Online engine via shared memory attachment. :-) > If your machine which is to be running the Online engine is to be > *exclusively* a database server and run absolutely no other software > except for the O/S, then you need to stick with just a very fast > single CPU box, or go directly to at least four CPU's.... and then when you've > got such a big installation that justifies a 4+ CPU SMP unix box, you'll > be running out of network bandwidth. :-) :-) :-) (smileys, lots of smileys) > snip.... Neal, old bean, history has shown you know your stuff, but I still must disagree at least in the context of 2 way Sparc 1000E + Solaris 2.4. I still contend Informix would and could not do such a sorry job of MP locking/coordination so as to chew up the entire second processor and then some, which is what it would take to produce less throughput than one processor alone. This in spite of the fact that's precisely what their documentation says they did.... Yes - I am talking about a pure database engine server, with very little else going on on the machine... i've tried it both ways, and i like both processors, with 2 cpuvps and PDQ MUCH better than i like one of everything... -- Greg Moye Electronic Data Systems Corp. - Plano TX