Re: Lousy performace

From: Amin Adatia <tmpaadatia_at_ptc.com>
Date: 1997/05/02
Message-ID: <336A3A42.4805@ptc.com>#1/1

Hi!

Try moving all your SQL coded triggers into Program_Units and then call these. The PUs are precompiled and should be a bit faster.

Regards

Kristian Cibulskis wrote:
>
> We have run into the same issues in implimenting an order entry system as
> well. The screen takes ~7 seconds to come up on P133 w/32 MB of ram and it
> takes nearly 2seconds to go line to line. We have ommited all implicit
> cursors and have moved nearly everything that we can to the database side.
>
> ANY hints on performance tuning for Oracle Forms would be very valueable.
> As of now I've found a total of about 10 tips in existence and am looking
> for anything that could help!
>
> - kristian
>
> >

-- 
Amin Adatia
KnowTech Solutions Inc (	amin_at_istar.ca	(613)226-8378 )
at Parametric Technology Corporation  		(617)398-6332

Received on Fri May 02 1997 - 00:00:00 CDT