Re: Performance problem with LOV
Date: 1997/09/29
Message-ID: <60p3tb$cu2_at_brown.telepac.pt>#1/1
That's amzing isn't it?
A Client/Server tool and it fetches every single record that is the object
of your query !
Try to make your query to depend on another item on your form to limit the
number of records to be fetched.
I've tried the same but with a dial (28800 using RAS from NT) connection and
the Software was ok until someone press the LOV key. (I was lucky the number
of records was only 1500 ....).
Now I've a block to perform like a LOV
Regards
natarajan usharani wrote in article <60mvnj$486$1_at_vixen.cso.uiuc.edu>...
>
>
>My environment:
> Forms version 4.5.7 on windows 95
> Oracle 7.3.2 database server running on AIX 4.2
>
>
>I have an LOV which takes about 1 minute to come up.
>
>The LOV is based on a record group whose query involves join of two
>tables.
>
>The number of records fetched by the LOV is about 2000.
>
>
Received on Mon Sep 29 1997 - 00:00:00 CEST