Greetings,
I have an application where the customer wants to export a report's data to CSV. I am using the 'Enable CSV Output' function on the report. It works ok initially with smaller data sets. But once the data set gets large (for example over 100,000 records) the process appears to run but 'hangs' and never comes back with the 'File Download' window. When testing with smaller data sets, it appears that it is exporting 90 records per second to create the CSV file in APEX. So for a report with 4000 records, it is taking approximately 45 seconds before the 'File Download' window pops up. By the end of 'season' for this application, I will routinely have over 100,000 records they will want to export to CSV. Testing with a report with over 100,000 records, if it takes 90 records/second, it would take approximately 18.5 minutes to run. When I test it in my APEX report and try to export the data, it runs and 'hangs' and the 'File Download' window never appears.
I also tested a data set with 111,000 records and tried exporting to a text file in TOAD, That process took 3 minutes to run. That is approximately 600 records per second. Much Faster.
So my question is, is there a faster way to export a report's data to a CSV but stay within the APEX application? As I say, I know I could use TOAD or SQL Developer, but the customer is going to need to export the data from this report from within their APEX application.
FYI, I did try looking at Denes Kubicek's 'Custom CSV Export' but that took approximately the same amount of time to run as using the 'Export to CSV' feature in APEX report.
https://apex.oracle.com/pls/otn/f?p=31517:227:4712959917249::NO
I am running Apex 4.1.1
Thanks in advance,
John