| Recordgroup taking too long to populate [message #81161] |
Sat, 18 January 2003 08:20  |
Godwin
Messages: 37
Registered: January 2002
|
Member |
|
|
Hello everybody,
I have about 30000 records in a table linked to other tables in a database. I wrote a query attached to a recordgroup to populate some record in forms6i.
The problem is that after i have run the form,it takes about 10 minutes before the recordgroup is populated. What do you think is the reason for such a delay.
I does the population using WHEN-NEW-FORM INSTANCE OR WHEN-NEW-BLOCK INSTANCE with this script:
declare
p pls_integer;
begin
p := populate_group('course');
populate_list('one.my_desc','course');
end;
pls help!!!!!
thanks.
|
|
|
|
| Re: Recordgroup taking too long to populate [message #81162 is a reply to message #81161] |
Sat, 18 January 2003 10:22  |
Julie
Messages: 98
Registered: February 2002
|
Member |
|
|
|
Does it take the same amount of time to run the query in sqlplus, straight against the database? If so, I think you should tune the query. Look online for the directions to run an explain plan. Search the output for full table scans (not partial index scans), and consider creating indexes to eliminate any full table scans.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
