Re: Performance problem Forms 4.5

Bas Kooiman (bkooiman_at_ibmc10.eniac.nl) wrote:
>Hi,
 

>I am testing a Forms 4.5 application. Performance is the biggest problem
>at the moment. Starting a new screen takes about 10 seconds. And also
>a query lasts a long time.
 

>I use the following configuration:
 

>RS-6000 with AIX 3.2
>Oracle Server 7.3.2 - I also tried Oracle 7.1
>SQL*Net V2 - I also tried SQL*Net V1
>Forms 4.5
>Pentium 75 with 32 Mb - I tried Windows 3.11 and Windows 95
>Ethernet 10 MHz

Bas,
  If by "starting a new screen" you mean loading the first form with F45RUN.EXE, here's something you can do to help: In the \ORAWIN\BIN directory you will find a program called CDEINIT.EXE. Put this in your Windows Startup group and it seems to pre-load several of the DLLs that are required for Forms Runtime. It has a memory penalty but with your 32MB machine you should be able to handle it. I've found this to roughly cut in half the amount of time required to load the runtime.
  If, however, you are seeing the big delay when calling one form from another, than the comments that others offered here apply. Check your SQL and PL/SQL code first (Explain Plan, etc.).   For what it's worth, we have been using Oracle 7.1.4, 7.2, and now 7.3.2 on two different RS-6000 using first AIX 3.2.5 and now AIX 4.1 and it works fine. We use 16MB Token Ring.   That brings up another point, since you are using Ether/10. Where are your Forms modules? If you are storing them either on a network fileserver, or in the database, and if your Ethernet load happened to be heavy, I can see where that would be another possible culprit in loading one form from another. Again, FWIW, we store forms modules as OS files on fileservers, keeping the rest of the Forms Runtime environment (EXEs, DLLs, etc) on the local workstation. Forms I've observed which are admittedly not large or complicated, take about two seconds to call from the first. You might try moving them (the .FMX files) to your local hard drive and see if anything changes. Hope this helps - Forms runtime has been a big issue for me lately as well. I understand...
Jim Deeming
Database Administrator
Boulder County Received on Wed Jun 12 1996 - 00:00:00 CEST