FourGen/Informix 5.03 Performance Problems

Greetings! I am trying to help out a client that is having what they consider to be major response time problems. They have an NCR Unix Box with quad Pentium 90 processors and RAID-5 disk drives. They have an "accounting" application that is OLTP. I have looked at the Informix tbconfig parameters and they seem reasonable. The disk layout of the Informix tables, dbspaces, etc., in raw partitions is sound. They have moved the physical and logical logs from rootdbs to a dbspace on another disk drive. They are using Inet between two Unix boxes with a 100 Mbit FDDI connection. Update Statistics is run nightly. tbstat is showing "%Cached Reads" of 98% and "%Cached Writes" of 93%. sar is showing practically no usage of the %usr, %sys, and %wio, with one max a day of 39% idle, the rest averaging a total of 74% - 85% idle. Given that Informix is tuned OK, I was wondering what else could be a problem. I would like to check out FourGen and the code that it generates. In my previous encounters, I have seen generated code that wasn't easy to follow. Other developers have told me that "trace" showed FourGen to be going through 9 - 10 levels of function calls just to get going (i.e., paint opening screens, etc., before it actually started banging against the database). If anyone has any suggestions as to database tuning possibilities, network Inet problems, or how to determine if FourGen is the problem, I would appreciate it. Thank you. Kerry Davids (dino@ix.netcom.com)