When type query in SQL Developer, it return data less than a second. When do the same in Oracle APEX it take much more time, over 5 seconds. I go in DEBUG section to see what's wrong, and it return this to me:
-IR binding: "APXWS_MAX_ROW_CNT" value="1000000"
I figure it out, that it returns more than 1.000.000 rows, and that's why is slower. But don't know how to fix it, to get approximately the same time as in SQL Developer?
"Leave the Maximum Row Count property null, so classic reports won't fetch all the way to this number and interactive reports won't introduce the analytic function count(*) over ().
Don't use a Pagination Type with a Z, so classic reports won't fetch all rows and interactive reports again won't introduce count(*) over ()."
source: http://rwijk.blogspot.ca/2016/11/performance-aspects-of-apex-reports.html (I saved it in the wayback machine too if the link goes away: http://web.archive.org/web/20170706183715/http://rwijk.blogspot.ca/2016/11/performance-aspects-of-apex-reports.html
Put some limits on Maximum Row Count and Maximum Rows per Page can help you to mitigate loading.
You never had same performance as SQL Developer in a web page apex or not.
