New server...

This is a multi-part message in MIME format. ------=_NextPart_000_00EB_01BFDC59.95114400 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I will be installing a new box next week, It's a Sun 3500 with 4 cpu's, 2 Gb mem, solaris 5.6 and Informix Dynamic server 7.31.UC4. Planned to handle 450 concurrent users, the databse will be unbuffered and most of the transactions will be inserts with few updates. Database conformed with up to 10 tables, 16 fields each (numeric), 15000 rows each. There will be running queries each 15-30 seconds, so the performance is an isue. Any advice in how to get the most performance will be appreciated. Patricio Riveroll Alvarez SISTEMAS Y COMUNICACIONES GRUPO SITEL DE MEXICO priveroll@grupositel.com.mx Tel. (52)5133-3328 FAX. (52)5624-2151 Cel. (52)2538-7632 Skytel: 5227-7979 Pin: 5576501 ------=_NextPart_000_00EB_01BFDC59.95114400 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 5.00.2722.2800" name=3DGENERATOR></HEAD> <BODY bgColor=3D#fffbf0> <DIV><FONT face=3DArial size=3D2><SPAN class=3D310374119-22062000>Hi,=20 </SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D310374119-22062000>I will = be installing=20 a new box next week, It's a Sun 3500 with 4 cpu's, 2 Gb mem, solaris 5.6 = and=20 Informix Dynamic server 7.31.UC4.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN = class=3D310374119-22062000>Planned to handle=20 450 concurrent users, the databse will be unbuffered and most of the=20 transactions will be inserts with&nbsp; few updates.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN = class=3D310374119-22062000>Database conformed=20 with up to 10 tables, 16 fields each (numeric), 15000 rows=20 each.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D310374119-22062000>There = will be=20 running queries each 15-30 seconds, so the performance is an=20 isue.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D310374119-22062000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=3DArial size=3D2><SPAN class=3D310374119-22062000>Any = advice in how to=20 get the most performance will be appreciated.</SPAN></FONT></DIV> <DIV><FONT face=3DArial size=3D2><SPAN=20 class=3D310374119-22062000></SPAN></FONT>&nbsp;</DIV><BR> <P><B><FONT face=3DArial size=3D2>Patricio Riveroll Alvarez</FONT></B> = <BR><B><FONT=20 face=3DArial size=3D2>SISTEMAS Y COMUNICACIONES</FONT></B> <BR><FONT = face=3DArial=20 size=3D2>GRUPO SITEL DE MEXICO</FONT> <BR><U><FONT color=3D#0000ff = face=3DArial=20 size=3D2>priveroll@grupositel.com.mx</FONT></U>&nbsp;&nbsp;&nbsp;&nbsp; = <BR><FONT=20 face=3DArial size=3D2>Tel.&nbsp; (52)5133-3328&nbsp;&nbsp; FAX.=20 (52)5624-2151<BR>Cel.&nbsp; (52)2538-7632</FONT> <BR><FONT face=3DArial=20 size=3D2>Skytel: 5227-7979&nbsp; Pin: 5576501</FONT> </P> <DIV>&nbsp;</DIV></BODY></HTML> ------=_NextPart_000_00EB_01BFDC59.95114400--