anumoses
asked on
oracle forms performance
There is lot of code in the form and has many tabs. User is complaining of the slow process when they query the location and warehouse. I tried commenting much of the code that I thought is slowing down the execute query. Which is the right place or form trigger that I should first look i to?
Help is very much appreciated.
Help is very much appreciated.
ITSS ... It's The Stupid Sql's
Ask the user to run the problem a few times
> This will place his querries in the sql cache
then you can query the sql cache and sort by consistent gets (aka buffer gets)
check this question.
it holds a few querries to help pinpoint the problem
https://www.experts-exchange.com/questions/29019895/replicate-in-oracle.html
Ask the user to run the problem a few times
> This will place his querries in the sql cache
then you can query the sql cache and sort by consistent gets (aka buffer gets)
check this question.
it holds a few querries to help pinpoint the problem
https://www.experts-exchange.com/questions/29019895/replicate-in-oracle.html
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
user will always want of these child records to be queried automatically when the parent block records are queried.
But if child records are on different tab then these child records can be queried when user clicks on the tab - it is When-Tab-Page-Changed trigger.
ASKER
correct. I agree.
ASKER
If I make "Deferred" set to "Yes" and "Automatic Query" set to "No", in the relations and add the code in when-tab-changed, will it improve the performance?
By my opinion yes, but you have to try it.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
Also if there are some calculations - see items with calculation mode Formula or Summary. If there are such items then block property Query All Records is set to yes and it can caused poor performance.
If it can be done you can use view instead of table as the block source and eliminate using of Post-Query trigger for filling non-base table items.