| global data in an oracle application [message #83058] |
Fri, 01 August 2003 02:38  |
lars
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
In our forms 6.0 application we want to reduce the startup-time of the individual forms.
In the startup trigger of each form there are several pop-lists which are filled with data (using recordgroups).
In many forms the same pop-lists are loaded at startup.
This means you have to wait +/- 5 seconds for the form to start up, although the same data has already been retrieved from the database in an earlier form.
Is there a way to increase the speed of form-startup, by loading the data ONCE in the SGA, and to fill the poplists with this data at form startup ? or is there an alternative way ?
Thx in Advance,
Lars
|
|
|
|
| Re: global data in an oracle application [message #83064 is a reply to message #83058] |
Fri, 01 August 2003 10:53  |
Ali
Messages: 88
Registered: March 2000
|
Member |
|
|
1. if u r using pre-form or when-new-form-instance trigger then reduce load from them cauz whenever u run form its populate recordgroups which take time.
2. its also take time if u use like operator in default where.
3. dont use post-change trigger on block level for fetching data use post-query instead of post-change.
these r some possibilities.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
