Performance Problems
630507Mar 30 2009 — edited Apr 8 2009Hello everybody,
I have a question regarding performance of ApEx apps.
If I have to develop a new report, it very often happens, that it takes lot of time till the report is displayed.
I am testing the SQL in SQL Developer. There it is executed within a few seconds (max. 10 at first and about 2 at second execution).
The same SQL in an ApEx Report might take minutes till it is displayed.
Since it is working fine in SQL Developer, what might I be missing for ApEx?
Can anybody give me a hint which settings for interactive Reports, ApEx itself or the database i should check to improve performance?
We really like our ApEx applications, but at the moment the performance is our bottle neck.
Regards, Tine.