Performance problem with LOV

[Quoted] My environment:

	Forms version 4.5.7 on windows 95
	Oracle 7.3.2 database server running on AIX 4.2
	

I have an LOV which takes about 1 minute to come up.

The LOV is based on a record group whose query involves join of two tables.

The number of records fetched by the LOV is about 2000.

The same query when run from a sqlplus session on the database server takes about 7 seconds.

The O'Reilly 'Oracle Performance Tuning' book mentions(chapter 9, page 168) that that there would performance problems if LOV is used to display all rows in a table which has more than 500 rows.

The author goes on and shows a way to improve performance by coding a special SQL*Forms popup window in place of the default pop-up window.
There is not much information in the book about

	how the pop-up window should be designed 
	will a record group be behind the pop-up window?
	how designing the pop-up will improve performance
	

Can someone give some hints on improving performance of LOVs which display many rows?

Thanks

Natarajan Murugaiyan(Ravi) Received on Mon Sep 29 1997 - 00:00:00 CEST