Home » Developer & Programmer » Forms » List of Values is Slow when fetching more than 6000 records
List of Values is Slow when fetching more than 6000 records [message #79393] Thu, 06 June 2002 02:43 Go to next message
Pradeep
Messages: 55
Registered: July 2000
Member
I have a query which is fetching More than 6000 records, the time taken to fetch the records in SQL editor is 170 m secs, where as same query through list of values(LOV) using forms 4.5(d2k) is taking more than 35 secs to display.
could u suggest me how to improve the Performance of LOV? the query is displaying all the records present in the table(ie full access of table)..

thanking u in anticipation,
pradeep
Re: List of Values is Slow when fetching more than 6000 records [message #79396 is a reply to message #79393] Thu, 06 June 2002 03:34 Go to previous messageGo to next message
Muhammed Shahzad
Messages: 10
Registered: November 2001
Junior Member
Use a query block on a different window and select from it.
Re: List of Values is Slow when fetching more than 6000 records [message #79398 is a reply to message #79393] Thu, 06 June 2002 04:19 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
Member
use hint /* first_rows */ in ur select statement... i'm not sure but this should work..

or increase the arraysize in developer..

cheers
ram
Previous Topic: how to avoid an empty items in poplist item
Next Topic: Calling a Word document in dev2000(forms 6)
Goto Forum:
  


Current Time: Sat May 25 13:33:10 CDT 2024