Performance

Forum|Forum|19 years ago
March 28, 2007
2 replies
378 views

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.

Advanced techniques

This topic has been closed for replies.

I

insuractive

Inspiring

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.

S

Sojovi

Inspiring

What technique are you using ? Writing to a file ? cfcontent ?