 increase speed of open form [message #286867] |
Mon, 10 December 2007 05:15  |
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
|
Senior Member |
|
|
hi all
i use oeacle 10g and form 6i .
i create form when open it open 300 cursors
(get data from 243 tables).
this from take about 2 min to open .
how can i increase speed of open form ?
thax
Rafeek
| Quote: |
--no of cursors
select a.value, s.username, s.sid, s.serial#,s.machine
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current' and s.machine like '%RAFEEK
|
[Updated on: Mon, 10 December 2007 05:16] Report message to a moderator |
|
|
|
| Re: increase speed of open form [message #286873 is a reply to message #286867] |
Mon, 10 December 2007 05:44  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Are you selecting a single row from many of those tables. If so, you can combine the queries.
Instead of
SELECT col1
FROM tab1
WHERE pk1 = :val1;
SELECT col2
FROM tab2
WHERE pk2 = :val2;
SELECT col3
FROM tab3
WHERE pk3 = :val3;
you can do this
SELECT tab1.col1, tab2.col2, tab3.col3
FROM dual
LEFT JOIN tab1 ON pk1 = :val1
LEFT JOIN tab2 ON pk2 = :val2
LEFT JOIN tab3 ON pk3 = :val3;
Ross Leishman
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
