Re: More processors or more MHz?

Posted in 1997

Ofer Inbar — 2 Apr 1997 15:09:07 -0500 — source: Informix-list mailing list archive (1991-1998)

satriguy@aol.com (SaTriGuy) writes: >From: cos@zax.whoville.leftbank.com (Ofer Inbar) >Date: 27 Mar 1997 12:37:19 -0500 >Message-ID: <5heb8f$ng2@zax.whoville.leftbank.com> >>satriguy@aol.com (SaTriGuy) writes: >>>Afraid that this is really an impossible question to answer. The're too >>>many variables based on requriements. >> >>Right, I realize that. I just don't have a firm handle on what the >>variables are, when it comes to how Informix handles its work. What >>should I be looking at... >The real question is what is the nature of our application. Is it more >oltp oriented or batch oriented? If there is a high probability of a lot >of concurrant usage, then you need multiple processors. If the >application is batch work, then a single higher speed processor might make >more sense. From the other thread I started about the same thing: > The scenario is: A CGI-based application, using ODBC to talk to an > Informix OnLine 7 server on another box. Lots of users will be > accessing the data via HTTP, and the CGI-based application will be > modifying their personal data. At the same time, local users may also > be modifying data in the same tables. The majority of accesses to the database, both reading and writing, will be web customers - several hundred thousand a month. Sounds like OLTP, right? If I've got multiple processors on the HPUX box, and there are simultaneous web "hits" and corresponding CGI instances accessing the database, will Informix 7.22 (or HP-UX) be able to hand those off to the different processors? >As a very general rule, more processors make more sense than a single >higher-speed processor. That's also what I thought, but someone else here posted the opposite. Where do these very general rules come from anyway? :-) -- Cos (Ofer Inbar) -- cos@leftbank.com cos@cs.brandeis.edu -- The Left Bank Operation -- lbo@leftbank.com http://www.leftbank.com/ "GUIs normally make it simple to accomplish simple actions and impossible to accomplish complex actions." --Doug Gwyn (22/Jun/91 in comp.unix.wizards)