APEX

Hi,

I am encountering a severe performance problem with loading an Interactive Report. When I run the page in debug mode it appears to spend the vast majority of the time(99.9%) on the process "Rows loop: 100 row(s)". I've looked into multiple possibilities but have not found a way to improve performance.

My initial thought was trying to tune my SQL, but according to the debug log, my SQL statement was executed in less than .005 seconds. I have not completely dismissed this as the cause, as this may still be affecting load times indirectly.

The settings that seemed to be in direct cause of the issue were the maximum number of rows to display and the maximum number of rows to query. I tried to configure each of these, but neither setting seemed to improve the loading times.

Any help/suggestions would be appreciated.

If you haven't encountered a similair problem, it would be particularly helpful if you could provide whether I should be looking into tuning SQL, tuning the database, configuring the APEX application, or configuring the APEX Listener.

Thanks,
Brian