Speed up ABF compilations

From:	Karl & Betty Schendel [SMTP:schendel@kbcomputer.com]
To:	Wallen, Alan; 'info-ingres@ams.org'
Subject:	Re: Ingres 4GL Compilation Speed

At 11:48 AM -0500 3/6/99, Wallen, Alan wrote:
>Compilations within Vision/ABF of a 4GL frame are now (subjectively)
>significantly slower than previously (factor of 2 or more). ...

Try changing $II_SYSTEM/ingres/files/dictfiles/cor02min.mfy
(the unix path, you'll need the vms equivalent)
so that the ii_objects structure is just btree on object_name instead of
btree on object_class, object_owner, object_name.  You can try
compression=(key,data) as well, although that may or may not help.
Then, do a sysmod.

The above will slow down the invocation of tools like vifred which
bring up an object catalog, but it should speed up 4GL compilation quite
a bit.


Karl R. Schendel, Jr.
K/B Computer Associates   schendel@kbcomputer.com
Ingres and Unix Expertise

President, North American Ingres Users Association
president@naiua.org
Ingres Q & A
Back to William's Home Page
Email William