Home » Developer & Programmer » Forms » increase speed of open form
icon12.gif  increase speed of open form [message #286867] Mon, 10 December 2007 05:15 Go to next message
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 Go to previous messageGo to next message
rleishman
Messages: 3724
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
Re: increase speed of open form [message #286898 is a reply to message #286873] Mon, 10 December 2007 06:43 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
i can not combine the queries
each qurey (cursor) independent
can i change (SESSION_CACHED_CURSORS , CURSOR_SPACE_FOR_TIME )
to increase speed of open form.

[Updated on: Mon, 10 December 2007 06:47]

Report message to a moderator

Re: increase speed of open form [message #288906 is a reply to message #286898] Wed, 19 December 2007 00:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: Message not getting displayed in 10gR2
Next Topic: How to submit form when hitting the ENTER key
Goto Forum:
  


Current Time: Sat Dec 03 00:56:48 CST 2016

Total time taken to generate the page: 0.09992 seconds