Question for Sun experts

Posted in 1999

Topics: Performance & Tuning, Stored Procedures & SPL, Platform-Specific Issues

Bashar Chalabi — Thu, 1 Jul 1999 13:48:54 +0100 — source: Informix-list mailing list archive (1991-1998)

Hello, We are usually a PC shop (NT and SCO). One of our clients insists on having a Sun server. They are horrified at the idea of PCs as servers. We have no experience of Informix on Sun, so here are a few questions: The application is mainly OLTP during the day with around 200 users. At night, there is a hughe batch run, written completely in stored procedures. 1. How does an UltraSparc II 400MHz compares with a Pentium III Xeon 500MHz. I know they are better, but would a Dual UltraSparc replace a Quad Pentium? 2. We have to choose between the Workgroup Servers (450) and the Entreprise Servers (3000). I assume the entreprise are faster machines, but the processors are the same. Will a typical database application see much better performance in an Entreprise server? 3. Is Informix 7.31 stable on Solaris 7, or is it better to stick to an older Solaris. Thanks for any help.

↪ replying to Bashar Chalabi

kbg — Mon, 05 Jul 1999 17:27:23 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I hope it's a 3500 you are talking about because if it's an old (2years) 3000 just buy a 450 the I/O are faster (I have both running Informix in here). Karim. Bashar Chalabi wrote: > Hello, > > We are usually a PC shop (NT and SCO). One of our clients insists on having > a Sun server. They are horrified at the idea of PCs as servers. We have no > experience of Informix on Sun, so here are a few questions: > > The application is mainly OLTP during the day with around 200 users. At > night, there is a hughe batch run, written completely in stored procedures. > > 1. How does an UltraSparc II 400MHz compares with a Pentium III Xeon 500MHz. > I know they are better, but would a Dual UltraSparc replace a Quad Pentium? > > 2. We have to choose between the Workgroup Servers (450) and the Entreprise > Servers (3000). I assume the entreprise are faster machines, but the > processors are the same. Will a typical database application see much better > performance in an Entreprise server? > > 3. Is Informix 7.31 stable on Solaris 7, or is it better to stick to an > older Solaris. > > Thanks for any help. -- __________________________________________________ La meteo par le Web : http://www.meteoconsult.fr Meteo Consult - Bureau d'etudes meteorologiques Domaine de Marsinval F-78540 Vernouillet, FRANCE Karim BEN GHANEM - mailto:kbg@meteoconsult.fr Departement Informatique tel : +33 1 39 65 80 80 - fax : +33 1 39 65 80 96