I'm experiencing a significant delay when downloading data from an interactive report. The output of the SQL query (approximately 97,000 records) takes 3-4 seconds to display, but the download process takes over 120 seconds. When running the same query in SQL Workshop, it downloads in 20 seconds, and switching to a classic report reduces the download time to 25 seconds.
APEX Version: Oracle APEX 21.2.0
**Database Version: ** 19c
Interactive Report:
It takes over 120 seconds to download.
Classic Report:
Downloads in 25 seconds.
SQL Workshop:
The output of SQL query is Downloaded in 25 seconds.
Solutions Tried:
I am using classic reports for download improved performance.
Questions:
- Why is the interactive report significantly slower for downloads?
- Are there any optimizations for interactive reports to improve download speeds
Any insights or recommendations would be greatly appreciated.