Re: Forms 4.5: problem with the size of the *.fmb files

Paul,

Much of the code DIANA and P-code stored in an FMB file is useless, and should not be stored there. Each time I open a form in the Designer, it re-compiles all the code which accesses the database. That's why it takes longer to open my form when connected than when disconnected. I suspect it re-compiles ALL code.

You can also observe this after opening and generating a form: Disconnect and reconnect, and then try generating. The generate step takes about as long as first opening the form. But subsequent re-generate steps are fast (and I thank you all at Oracle for that).

So my point is that there is no advantage in storing compiled code in the .FMB file if it is discarded and redone each time a form is opened. It is just wasting space.

Do you not agree?

Regards,
Steve Cosner

In article <4apumu$r05_at_inet-nntp-gw-1.us.oracle.com> pzola_at_us.oracle.com (Paul
  Zola ) writes:
<snip>
>In order to support incremental compilation, Forms 4.5 must store
>additional information in the .fmb file. Specifically, Forms 4.5
>stores all of the PL/SQL source text, the DIANA (intermediate
>representation) and the compiled PL/SQL P-Code in the .fmb file. The
>DIANA and the P-Code are only created when the form is generated or
>when the specific program unit or trigger is compiled.
>
>This simple fact accounts for all of the observed phenomena:
> - The .fmb files are larger in Forms 4.5 than in Forms 4.0
> because they are storing more information.
> - Generating a form (or selecting 'compile all' will make the
> .fmb file larger.
> - Converting to an .fmt file and then back to an .fmb file will
> shrink the file, since the DIANA and the P-Code are not stored
> in the .fmt format.
>
>Note that the sizes of .fmx files are not affected by this phenomenon:
>an .fmx file only contains (and has always contained) the compiled
>P-Code.
>
> -paul
>
>==============================================================================
>Paul Zola Senior Technical Analyst World-Wide Technical Support
>------------------------------------------------------------------------------
>GCS H--- s:++ g++ au+ !a w+ v++ C+++ UAV++$ UUOC+++$ UHS++++$ P+>++ E-- N++ n+
> W--(+>++)$ M+ V- po- Y+ !5 !j R- G? !tv b++(+++) !D B-- e++ u** h f-->+ r*
>==============================================================================
Received on Fri Dec 15 1995 - 00:00:00 CET