Re: Performance Tuneing

In article <CoGFD9.HpF@utnetw.utoledo.edu>, crszczub@jupiter.cse.utoledo.edu (craig szczublewski) writes: |> Are there any notes available on performance tuning for Informix 5.01.UD2 |> running on NCR/ATT 2.20 Unix? The box is a NCR 3450 with 128MB RAM and |> about 10 GB Disk. Is there any thing I should look at in particular to |> make it run a little faster? |> |> Craig Szczublewski |> Unique Systems, Inc. |> |> crszczub@jupiter.cse.utoledo.edu |> I believe that there was a problem with the port to the NCR boxes. Walmart had a problem with a huge NCR configuration running w/~170 users. I don't remember the particulars, I _think_ there was a problem with the type of wait the engine was doing, but don't quote me. I can find out if you need it, but it involves a long distance phone call. Look at buffer and disk utilization in the engine, followed by application usage, especially cursors, first. DCT