Re: lov store in client side

KULJEET wrote:

> hi
> i am using forms(developer 6) on web application
> the main issue is performance
>
> if lov comes from large table then it will takes time
> so is it another way to store lov on client side.
> just like cookies.
> thanks in advance

It can be done but the cure is worse than the disease.

A better solution would be to shorten the list. For example ... provide a radio-button or checkbox that limits choices.

If the record group has a WHERE clause be sure there is a corresponding index and that statistics on the database are kept current.

--
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)