Choice of CPU configuration for new IDS10 instance.

Greetings gentlemen, We are defining the hardware configuration for a new Dell 2950 that will run IDS 10 to serve a traditional OLTP database of about 10-20 GB with ~100 -150 concurrent users or so. OS will be RHEL 5, architecture is Intel-64, 8GB of RAM. Given the choice between: 1) Two Dual Core Intel® Xeon® 5130, 4MB Cache, 2.00GHz, 1333MHZ FSB 2) Two Quad Core Intel® Xeon® E5310, 2x4MB Cache, 1.60GHz, 1066MHz FSB .. what would you choose? Option 2 seems definitely better as it would make 8 processing cores available to IDS instead of just 4, but as you can see they woud also run at ~20/30% slower clock and FSB speeds. Curious about the thoughts of the people in this illustrious forum :) thanks all -- Danilo.

Well... after 6+ years of working with Informix here at George Fox University, our ERP vendor has decided to discontinue the product we're on, and support will trail off to none by 2011 (we've already seen a huge drop in support as their people move to other products). So we've had salesmen and demos over the last 3-4 months. A decision has been made. We're going with a vendor that only supports Oracle. I've grown to really love Informix -- it just works. We've had a variety of issues with our systems over the last 6 years (boot drive failure, network adapter problem, etc) -- the only problem that had anything to do with the Informix database was when I pulled a wrong drive out of the box and downed a dataspace by mistake. Support from Informix has been great. Going up on a new system needs to be timed around the academic schedule -- it will be about a 2-year process. So we'll keep Informix running for at least a couple years as we get the new system in, translate our data, move the various offices onto the new software, etc. But I wish we could have gone with a system that supports Informix. I really wish we could have. Brian McLaughlin Administrative Computing George Fox University (503) 554-2587

>> "Danilo Fiorenzano" <tomade@gmail.com> wrote in message >> news:1180722273.637349.10650@q75g2000hsh.googlegroups.com... Greetings gentlemen, We are defining the hardware configuration for a new Dell 2950 that will run IDS 10 to serve a traditional OLTP database of about 10-20 GB with ~100 -150 concurrent users or so. OS will be RHEL 5, architecture is Intel-64, 8GB of RAM. Given the choice between: 1) Two Dual Core Intel' Xeon' 5130, 4MB Cache, 2.00GHz, 1333MHZ FSB 2) Two Quad Core Intel' Xeon' E5310, 2x4MB Cache, 1.60GHz, 1066MHz FSB >> .. what would you choose? Option 2 seems definitely better as it would make 8 processing cores available to IDS instead of just 4, but as you can see they woud also run at ~20/30% slower clock and FSB speeds. Curious about the thoughts of the people in this illustrious forum :) Well I certainly wouldn't buy a Dell for a start. Do you like speaking to "support technicains" who can barely speak your language, are reading from a script, and are courteous and useless in equal, deep measure?

On Jun 1, 8:24 pm, Danilo Fiorenzano <tom...@gmail.com> wrote: > Greetings gentlemen, > > We are defining the hardware configuration for a new Dell 2950 that > will run IDS 10 to serve a traditional OLTP database of about 10-20 GB > with ~100 -150 concurrent users or so. OS will be RHEL 5, > architecture is Intel-64, 8GB of RAM. > > Given the choice between: > > 1) Two Dual Core Intel® Xeon® 5130, 4MB Cache, 2.00GHz, 1333MHZ FSB > > 2) Two Quad Core Intel® Xeon® E5310, 2x4MB Cache, 1.60GHz, 1066MHz FSB > > .. what would you choose? Option 2 seems definitely better as it > would make 8 processing cores available to IDS instead of just 4, but > as you can see they woud also run at ~20/30% slower clock and FSB > speeds. Curious about the thoughts of the people in this illustrious > forum :) > > thanks all > > -- > Danilo. I expect that both should have enough CPU power for such a fairly small database and moderate number of users. I suggest to get option 1) and invest the money saved in CPUs and especially in licenses (I suppose that with 2 x 4 CPU cores you would spend considerably more on licenses) into better I/O subsystem (more and faster controllers and disks and better data protection) or protecting budget for DBA's salaries increase :-) With these new CPUs you should probably set more than 1 CPUVPs per physical CPU core to use CPU power effectively. Personally, I prefer HP/Compaq Proliants when speaking of Intel/AMD based servers, but that is just personal preference. I also prefer SLES when choosing Linux platform for Informix, but that's another personal preference. Darko Krstic