Re: FourGen/Informix 5.03 Performance Problems

Posted in 1997

"Billy Wheeler" — 11 Jan 1997 13:23:31 -0500 — source: Informix-list mailing list archive (1991-1998)

On 10 Jan 97 at 18:52, Kerry Davids wrote: > 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. Well, here's your problem: it's FourGen, isn't it? :-) > 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). How many users do you have? The bottom line is FourGen is a resource hog, no way around it, I'm afraid! -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...