Re: Webforms List of Values

>We are using the Forms 4.5 web runtime application to run 32 bit forms on
>the
>web..when selecting a List of Values it takes almost 30 seconds to display
>the first list, after that it is under five seconds....does anyone know away
>to
>speed up the process by using a pre-form trigger or something??
>
>
>
>

The LOV process involves loading all the values that meet the criteria into memory. If there are a lot of rows returned (I have used LOVS that returned over 2000 rows, which loads in 5-10 seconds, but that is dependent on a lot of things...), this can take a while simply for the network traffic and ememory allocation, etc.

There are 2 LOV settings that are relevant, but I don't recall the exact names... one is something that controls if all the values are loaded before any are displayed.. something like a Y/N value labeled "Big List". Track down this setting. It will make the first ones display faster, but as the users goes down the list, the rows have to be retrieved, so it will be slower then.

The other setting controls if the LOV is reloaded each time it is invoked, or the values are cached. The default is to use cached values, and it sounds like that is what ius going on for you.

If you can do anything programmactically to reduce the number of rows retrieved, that would probably provide the most benefit. (You can use form variables in a where clause by simply referencing them as :block.variable). By clever usage of decodes and nvls, you can do a lot to show just rows that really make sense.

All this is based on my experience on pure client-server stuff; I am assuming it is reasonably applicable to Forms running on the web. Good luck

Dan Hekimian-Williams Received on Wed Dec 02 1998 - 04:45:22 CET