Great, this would be a job for the database not CF imo...create a DTS package that writes out the csv file. Then either fire the DTS via an SP, or use the DTS Object Model to execute.
This can be a bit complex, but not overly, and the DTS should be able to complete an export of 150k lines in a few seconds, quite an improvement from 30 minutes :) I've made a lengthy posting on how to do this in the past, and I think I can dig it up if you are interested. -- jon mailto:[EMAIL PROTECTED] Tuesday, March 11, 2003, 6:25:23 PM, you wrote: WC> [EMAIL PROTECTED] writes: >>Which database are you using? WC> We're on SQL Server 7.0. WC> I should add that the query itself doesn't seem to be the problem -- it WC> returns in a matter of seconds. The lag is almost certainly happening in WC> the process of looping through the query results and appending each line WC> to the file. WC> Thanks. WC> _______________ WC> Wendy Copley WC> Web Engineer WC> [EMAIL PROTECTED] WC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
