Question about LOVs and "Record Group Fetch Size" property
529448Apr 23 2007 — edited Aug 17 2013Hi:
For some reason, in our application, a couple of users have been sporadically experiencing the following issue with and LOV:
They invoke the LOV. Note: Query associated with the LOV retrieves 750 rows.
They used the scrollbar to move down the list. At some point during the scroll, their screen turns white and stays white for several minutes.
A couple of days ago I had a chat with one of my friends from a previous job and he told me that when they converted to forms on the web, they observed this behavior and that he was pretty certain that this was due to a property associated with the LOV. I looked at all the properties associated with the LOV object and none strikes me as being related. I did find the "Record Group Fetch Size Property" in the record group and it seems to be related. Does anyone know if indeed this property has a connection to our behavior?
My friend also told me that they basically had to create an LOV look alike solution using a form block. I believe I saw a solution doing this a while ago. Does anyone know where I may find it?
Thanks,
Thomas