Re: Big System... Is Oracle Forms Good?

ozone@primenet.com (John R. Moore) writes: One area of concern is the speed of your network. SQL*Net version 1.2 and previous versions is a pig. You MUST use SQL*Net version 1.2 which means you must develop on Oracle version 7.1. Another area of concern on a complex application is the memory utilization. SQL*Forms 3 and 4 are both heavy on memory. SQL*Forms does not always dealocate memeory after a large form is executed. I doubt that anyone will tell you that SQL*Forms is faster than PRO-C or an equivalent - except for a programmer. Development time on a complex application is considerably less than development in a c environment. This often compensates for the extra hardware requirements. Oracle version 7.1 offers a new multi threaded server that can be of enormous benifit in a client server environment. I have worked with a huge application ( over 500 Meg ) with a user count of near 1000. >Is Oracle Forms a good tool for developing complex client-server applications >that will have high volume (say, 1000 simultaneous users)? Is so, why? If not, >why not? On a complex system, does one still get the "performance payoff" that >the 4GL/screens-handler promises? If not, why not? What sort of gotchas are >out there? Has anyone out there done a large Oracle Forms project and had it >succeed or fail? > Would one be better off with C or C++ under a transaction manager? How about software complexity? >Thanks in advance >John Moore >---- >John Moore NJ7E - mailto:ozone@primenet.com - http://www.primenet.com/~ozone/ >...Politicians are like diapers: both need to be periodically changed for the same reason...