Try increasing the Record group fetch size to make the
lov display faster. And to make validation faster
write a when validate and make lov for validate
false... I have seen this run faster.
Regards
Alroy
- grace lim <mglim_at_softhome.net> wrote: > to
validate user's input, i use the validate from
> list of lov. and it
> takes for the lov a long time to displays all the
> available customers in
> the database. what can u suggest to make it faster
>
> At 06:46 AM 5/26/00 -0800, you wrote:
> >2K to 3K rows for a LOV? You probably need to
> redesign or restrict the LOV
> >query criteria. LOV works best with few hundred
> rows, not thousands of rows.
> >
> >HTH
> >Raj
> >--
> >Author: Jamadagni, Rajendra
> > INET: rajendra.jamadagni_at_espn.com
> >
> >Fat City Network Services -- (858) 538-5051
> FAX: (858) 538-5051
> >San Diego, California -- Public Internet
> access / Mailing Lists
>
>--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an
> E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB
> ORACLE-L
> >(or the name of mailing list you want to be removed
> from). You may
> >also send the HELP command for other information
> (like subscribing).
> >
> >
> --
> Author: grace lim
> INET: mglim_at_softhome.net
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
Received on Sun May 28 2000 - 06:41:30 CDT