 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ColdFusion / Advanced Techniques / March 2007Performance
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. What technique are you using ? Writing to a file ? cfcontent ? Do you need to do it from code? If not you can do this easily in Oracle SQL Developer which is free. 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.