Re: Forms6i SLOW

Perlie wrote:

> Hi
>
> We have problems with an application under Oracle Forms 6i running on
> WinNT Clients / Solaris DB. What works reasonably well at the start of
> a session slows down to a mere crawl. This is regarding forms
> navigation and the displaying of the data which both are VERY slow
> after sometimes only half an hour, sometimes after a couple hours.
>
> The application was originally created under Forms 3 and ported to
> Forms 6i. It has a starting form, from which the user chooses the
> actual form he wants to work with. The form of his choice is then run
> with CALL / CALL_QUERY (Forms 3), CALL_FORM (Forms 6i) respectively.
> When the user has finished with the form the control is passed back to
> the starting form (with EXIT_FORM) from where he chooses the next form
> to work with etc.
>
> This all worked very well under Forms 3. However under Forms 6i things
> slow down after 20-30 times changing to a different form. In this
> state while scrolling in a multi-row block the individual lines of
> data temporarily disappear, you can only see the background of the
> form. Only after releasing the key/mouse does the data appear again.
> Etc. Etc.
>
> When the Forms session is terminated and a new session is started,
> performance is once again OK. The client itself does not need to be
> rebooted. In the Windows Task Manager everything looks fine, no memory
> problems, no cpu load during and at the end of the forms session. We
> have inspected V$OPEN_CURSOR for a leak there but not found any
> indication for it.
>
> Has anybody got some advice apart from changing the application
> structure (calling of other forms)?
>
> Thank you in advance.
>
> Perl News

You are working in Forms 6, not Forms 3.

Get rid of the antique calls and use current syntax.

GO_BLOCK('<block_name>');
EXECUTE_QUERY; and

OPEN_FORM() and I'd suggest creating a menu rather than using a base-form.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
http://www.outreach.washington.edu/extinfo/certprog/aoa/aoa_main.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)