List of Values is Slow when fetching more than 6000 records [message #79393] |
Thu, 06 June 2002 02:43 |
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
|
|
|
|
|