Is there a SQL unLoader?
I need to create a file that can be downloaded from the database.
Here is the scenario:
A contact manager db online -
A user runs executes a page that displays site/contact information from the
database.
The user then use a dynamic sql generator to filter the records. (anywhere
from 100 to 15,000)
After filtering to the records they desire, they click a link that writes a
csv, and allows the file to be downloaded.
Currently, I am using <cffile> to write the file.
Problem is: the cf server/iis server is tied up processing for 10 - 15
minutes or more writing the larger files.
My goal is to reduce the time by (hopefully) utilizing the database to write
the file instead of the cf server.
I have the same application running with mssql server, I use the xp_cmdshell
to call the bcp program to write the files, it works great. I am trying to
repeat this with oracle.
We are using oracle 8i
Please help.
Chris Hamer
Web Development
ImageServe, Inc.
http://www.imageserve.com
[EMAIL PROTECTED]
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
