Informix on SCO UNIX ODT 2.0

I am currently trying to evaluate whether our current system is running optimally with the Informix 4.10 we have installed. We are running a DEC 433MP with 64 Megs RAM, 4 Gigs HD (software array), 2 486/33 processors, and miscellanous other boards. On an average we have about 20 users on the system at one time. The users execute a fglgo program for the 4gl application designed inhouse. From what I can tell the system continues to swap and system resources seems to be drained to the point, when someone does a query you can expect a 30-60 second delay in getting characters on the screen. Question I have is, does the 4gl programs use a lot of memory? How can I determine if the 4gl program is designed improperly or using resources incorrectly. Can a company rely strictly on 4gl code compared with 'C' code intermixed into the database applications. We are not using Informix as a OLTP but an accounting package. I know nothing about Informix but am a software engineer who must propose system expansion, upgrading, and other related issues to this Informix Server. I sense it is more a 4gl programming error than a lack of system power (resources). Any suggestions would be most appreciated. If I must upgrade my system, I must be able to show that the upgrade is justified. I would first like to discount any areas related to the Informix programs before I start dealing with the hardware. Also, if any one can explain what the need would be to get the ESQL/C package I sure would like to hear from you. What advantages would I gain from this compared to the straight 4gl development kit. Just for history, the individual who is writing the 4gl code is not a true developer but a user put through the Informix courses. Should the company spend a couple of thousand dollars to put a developer through the course as backup even though the developer would not do much 4gl coding? Can that developer assist the company at a lower level and benefit from the Informix courses? Regards, Chris Fryett cfryett@aol.com