Re: Running on Compaq Proliant

In article <2hudhvINN494@emory.mathcs.emory.edu>, Paul Pryor <ptp@fallschurch-acirs2.army.mil> wrote: >> > We're thinking of moving to this 4-Pentium machine, running SCO and >> > Informix SQL and 4GL (not Online, probably). >> > >> > Anybody had any experience with this, performance tuning tips, etc.? >> >> FWIW, we've just tested one of these for a customer, Informix worked >> straight out of the box as well as the Informix-based app they will >> be running. > >We had the opportunity to test Informix 5.0 Online running on >Sequoia (multi-processing, fully fault tolerant system), and >conduct a benchmark/performance evaluation test. Sequoia is >fully symmetric multi-processing system with its own TOPIX >Unix-like operating system. Very, very nice system. Could >install up to 128 cpu's in the system. > >Found out that Informix 5.0 runs on only one processor, even >if other processors are available, because 5.0 was not designed >for execution on more than one processor at same time. > >Don't know about SE, but I believe the restriction was due to >multi-process concurrency issues in Informix 5.0. By the way, >Informix rans fine out of the box on the system. > >Bottom line is that Informix 5.0 may run fine on multiprocessing >system, but it would be good idea to find out if it will run on >more than one processor concurrently. I may missunderstand the statement above but Infomix 5.0 SE and Online are available on several SMP systems that will 'execute in on more than one CPU'. How well they scale is very application dependent, but you should expect On-line to scale much better on SMP systems than SE, that's one of the thing's it's designed to do. Also with SE there may be a diffrence between platorms as to how the concurrency control was done, I believe there was at least one platform that avoided the high overhead of System V file locking to do concurrency control. For any real workload, especialy those where you have serious concurrent multi-user activity you want On-line not SE, especially on SMP systems. Cheers Darryl