Hi All,
I'm hoping you may be able to assist. We've recently migrated our database and APEX instance from a hosted server to Oracle cloud.
For some reason, on our new server, any time we download a CSV file through APEX's inbuilt download functions (Interactive Report -> Action -> Download -> CSV or adding the download as CSV link to a non interactive report), the speed to generate the CSV is awfully slow.
For example, we have a report on a table with no joins (1000 rows). The query inside the report runs in less than a second on the page, and within SQL Developer. When choosing Download as a CSV from the actions bar, it takes 14 seconds to generate the file before it downloads.
This seems to get exponentially worse - a 100,000 line report that utilised a number of joins takes 240 seconds to generate and download - yet the whole query will run on the page and within SQL Developer in 6 seconds to select all rows.
Interestingly, if I select the HTML option when downloading from the interactive report actions bar, it generates and downloads that in a matter of seconds. This points me to some bug or issue with the CSV generation code built into APEX and that the database seems to be running as efficiently as it should
Is anyone aware of what APEX actually calls to generate those CSV files, and if there are any known bugs or patches for this?
I would be incredibly grateful if anyone has seen this before or can shed any light.
Kind Regards
Seb
Version: Application Express 4.2.5.00.08
Database: 11gr2