Re: Informix performance on 1, 2 or 4 processors??

>Please Help! I am getting conflicting answers. Welcome to the wonderful world of system tuning. Get used to it. :) >HP and Informix say performance on 2 processors (1 for OS & 1 for DB) >is fine. It is very fine, thank you, for customers whose needs are met by that configuration. That may be you! Define "fine" and we'll see what it takes to attain that specification. When I used to run hot rods, we had a saying: "Speed costs money. How fast do you want to go?" >A user I know says they heard at an Informix Performance Seminar at >last summers World Wide Conference that performance on 2 processors is >a "real dog"!! This user says I should be on a 1 or 4 processor but >NOT 2 processors !!?? Believe half of what you read, and none of what you hear. (So I hear.) Here are some things to read: "Informix-OnLine Performance Tuning" by Liz Suto See especially page 93 (in the first edition) "Informix-OnLine Dynamic Server Administrator's Guide version 7.1" Chapter 10, page 10-19 "CPU Virtual Processors" and Chapter 38, page 38-59 "SINGLE_CPU_VP" "Informix-OnLine Performance Tuning Guide" Heck, just read the whole thing In summary: Performance is excellent if your needs are being met. It is NOT! measured by how many CPUs you have. Unless your needs are exactly the same as another's, be wary of comparisons between your benchmarks. And (I just gotta say it) RTFM. Happy computing, ______________________________________________________ Clem Akins (aka clema@informix.com) Informix Software, Inc (Standard disclaimers apply) International Technical Support Last seen: In KL, near the World's Tallest Building