Home » Developer & Programmer » Forms » LOV performance issue
LOV performance issue [message #183649] Fri, 21 July 2006 13:50 Go to next message
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 #183682 is a reply to message #183649] Sat, 22 July 2006 00:57 Go to previous messageGo to next message
RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
Senior Member
Hi,

Performance of the LOV is based on the underlying query, so you must tune that.

Regards
Rob Zijlstra
Re: LOV performance issue [message #183858 is a reply to message #183649] Mon, 24 July 2006 03:19 Go to previous messageGo to next message
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).
Re: LOV performance issue [message #184773 is a reply to message #183649] Thu, 27 July 2006 22:43 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at using the 'Long List' facility of the LOV.

David
Previous Topic: Hierarchical Tree
Next Topic: Pl/sql Record
Goto Forum:
  


Current Time: Sat Dec 03 22:40:18 CST 2016

Total time taken to generate the page: 0.12683 seconds