LOV performance issue [message #183649] |
Fri, 21 July 2006 13:50  |
chimbs
Messages: 32 Registered: April 2005
|
Member |
|
|
Can anyone please tell me how to improve the performance of an LOV.. Since the record count is more the 60000 its taking a hell lot of time..
|
|
|
|
Re: LOV performance issue [message #183858 is a reply to message #183649] |
Mon, 24 July 2006 03:19   |
jowahl
Messages: 82 Registered: May 2006
|
Member |
|
|
rows of a LOV are always loaded completly before displayed in the form.
if you have a huge number of rows maybe it's better to create a LOV-like form where you have better control what records will be fetched.
but if you still want to use the built-in LOV, you could prevent users to call a LOV by checking how many rows the LOV would return (e.g. in the KEY-LSTVAL trigger).
|
|
|
|