RE: Which IBM server is better for Informix

The typical answer is: It depends Can you provide more information about your workload and table definitions? Is it OLTP or DSS. For DSS I prefer more CPUs. Are your tables fragmented? If so, how many dbspaces are used for your largest or highest activity tables? More CPUs allow more parallelism. However, Art Kagel suggests that 450 MHz CPUs are fast enough to support 2 CPU VP's each. Rick > -----Original Message----- > From: remics@my-deja.com [mailto:remics@my-deja.com] > Sent: Tuesday, November 30, 1999 13:00 > To: informix-list@iiug.org > Subject: Which IBM server is better for Informix > > > Is there anyone out there who could help us? > > Here's our case: > > We are currently using IBM SP2 high node, 8-way CPU's with 200MHz in > speed but since our load is too high where we max out our CPU's we are > considering getting an IBM S7A, 12-way CPU's with 262MHZ or > an IBM S80, > 6 CPU's with 450MHZ. Now, our question is, which one is better for > informix database (7.3x) more CPU's but lower in speed or a lesser > CPU's but faster in speed. > > Thanks for any input. > > Erick > > > Sent via Deja.com http://www.deja.com/ > Before you buy. >