RE: Informix platform selection

I thought 64bit eliminated the 2 gig limitation on dbspaces and/or tablespaces. Barbara A. McCabe-Reed breed@sikorsky.com (203) 386-6431 -----Original Message----- From: Murray Wood (IList) [mailto:ifxmaillist@quanta.co.nz] Sent: Thursday, January 29, 2004 3:29 PM To: informix-list@iiug.org Subject: RE: Informix platform selection We find that Intel platform servers (linux, windows, etc) run out of power long before the client reached 150 users on the database. This is often including disk IO. We do normally run the application and database on the same server (except windows). Over 50 users we supply IBM or SUN servers (we have no HP servers but expect them to be the same). Would only use 64 bit Informix if there was a real reason for installing it. In the past (on 7.31) we found the 64 bit engine uses more initial resources for the same performance. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of Jason Dinsdale > Sent: Friday, 30 January 2004 1:54 a.m. > To: informix-list@iiug.org > Subject: Informix platform selection > > > Hello all, > > Currently we run Informix 9.2.1 (32 bit) on an aging HP L2000 (dual > 360MHz PA-RISC, 1Gb memory, software RAID) and we are now looking at > replacing it with something that will give a decent (x3?) performance > boost, most probably a 4-way server, hardware RAID, and lots more > memory (4Gb+). Currently I'm looking at a Linux (RedHat) server x86 > (Zeon or Opteron) as our most likely substitute O/S, but I'm also > considering Solaris and HP-UX/Itanium. We will most probably upgrade > to 9.4.0 as part of the migration. > > FYI our database is a rather modest 16Gb, with about 150 concurrent > connections. > > My questions for you are: > > - What are your experiences of running Informix on any of these > platforms and are there any curveballs I should be wary of? > - I'm told that 4-way servers are the performance 'sweet spot' for > Linux - true? > - Can I expect any sort of performance boost by upgrading to 9.4.0? > - Is there any real advantage to going to 64-bit Informix, and if so, > what is the migration path like? Simply a binary upgrade or is there > more to it? > > Thanks for your time. > > Jason Dinsdale sending to informix-list sending to informix-list