Re: Form50 LOVs

stevec_at_zimmer.csufresno.edu (Steve Cosner) wrote:

>In article <369F0023.5158B87_at_EEXI.GR>, DINOS <CC_at_EEXI.GR> wrote:
>>Has anyone used the property record Group Fetch Size in Record Groups of
>>Forms 5.0? Does it work ?
>>
>>I see that there is no difference in response time of LOVs from the
>>server for 20.000 records retrieved in relation with the forms4.5
>>(Both LOVs are too slow!)
>
>You should not be using an LOV to load a table with 20k rows. Use
>some other means, or allow the user to indicate which rows should be
>displayed. Once you get all 20k rows loaded, I don't think your users
>are going to want to scroll through all of them.
>
>Steve Cosner
>http://members.aol.com/stevec5088

With a LOV of this size, specify that it is a 'long list'- this will allow your users to reduce the returned rows to those closely matching what they need....

To reply please remove the 'nospam' part of the address Received on Wed Jan 20 1999 - 16:56:54 CET