Re: SE 5 tuning/optimizing on SCO
Franz Gr'tzmacher wrote:
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0167_01C3A3A4.E0547020
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi All
>
>I need some pointers in tuning (Optimizing) our Informix SE server.
>SCO Unix vers 5.0.5
>Informix SE 5.08.UD1
>SQL vers 4.17.UC1
>RDS vers 4.17.UC1
>
>We running a Pentium Pro with a SCSI hd and 128meg ram. Disk space 67% =
>used.
>=20
>sar reports the following, when a user request a month report:
>3.2v5.0.5 PentII(D)ISA 11/05/2003 =20
>08:53:05 %usr %sys %wio %idle (-u) =
> =20
>08:53:10 1 2 98 0 =
> =20
>08:53:15 1 2 97 0 =
> =20
>08:53:20 1 1 98 0 =
> =20
>Average 1 2 98 0>
>I have tried to optimize the 4gl code and indexes to these reports and =
>tables.
>
>Would it help if we would install a second IDE hard disk on the=20
>onboard IDE controller and use it for the database log files?
>I take it more ram will also help...? Any other idees?=20
>
>Blessings from Cape Town the gateway to Africa.
>Franz
>
>
>
>
Quick and dirty answer:
How many users are you running? 128 MB should be OK for let's say 10 users.
How large are your largest tables (number of records/size in MB of .dat)
Unload, drop and reload your largest tables or at least drop/create
indexes on them.
Second disk might help, but stay away from IDE, they cannot queue
operations
like SCSI can.
HTH
Michael
P.S. Don't post HTML.