I am exporting data in excel file (around 45000 records)
using cffile in Cold Fusion.It is taking around 45 mins in
exporting the data. Is there any other way to export a file from
oracle database, so that performance could be increased. I tried
through procedures in oracle and called them in cold fusion through
cfprocresult , but still performance is not increased.
This might be a better question for the Oracle forums. There
has to be a method for exporting data in your database to an excel
readable format (i.e. CSV or TXT). I could tell you how in MS SQL,
but unfortunately I don't have any experience with Oracle.