Oracle Forms WAN Performance

I have a application which is implemented as around 180 fmx files in 16bit Forms 4.5. Each fmx is coded to contain 1 window (with multiple canvases, etc.). Window-to-window navigation is accomplished by calling and executing the new fmx in each case. This works pretty well from a version control and maintenance standpoint, but I believe it is causing us problems with performance. Each fmx is taking like 10 - 20 seconds to open even on the LAN, and the files are only 150-300K apiece, so it isn't the file server. Over the WAN, the fmx's are still on a LAN file server, so it is not an issue there either.

The issue *seems* to be all the initialization that Forms does when it opens a new fmx file--it issues something like 30-40 queries for information such as the date format, the currency, the language, etc.--items which are never used by any of the forms.

Surely all Forms applications aren't this slow. What are we missing here? Is this initialization code in a package we can remove? Is there some command-line parameter we missed to turn off all this stuff or what?

Thanks for your help in advance,
Keith Fulton Received on Tue Jun 02 1998 - 13:34:18 CDT