Re: FourGen/Informix 5.03 Performance Problems

Have you investigated record locking ? Kerry Davids <dino@ix.netcom.com> wrote in article <5b5vib$3n8@sjx-ixn5.ix.netcom.com>... > 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) > >