I have released a UDF over at cflib.org, that will convert a ColdFusion query to "CSV" using JavaString Buffer which is considerably faster.
http://www.cflib.org/udf.cfm?ID=1197 Thanks and let me know if you have any problem. Qasim On 7/24/07, Garth Young <[EMAIL PROTECTED]> wrote: > > Hi, > > There have been previous posts about writing large data files from > database queries and I have the same problem. The files I need to create > may be up to 200-300MB in size (csv). I haven't tried in off-peak time > but when I tried a large queries during normal hours it got a memory > error. > > Does anyone know if there anyway to stream the results of a query which > I can then write to a file? Java has been mentioned for the file > write. Is there any way to stream the result of a query in java, > ColdFusion > or similar? > > One option is to write a file using PL/SQL but with the current > secruity policies it looks to be a time consuming process to get the > appropriate permissions in place. > > Cheers > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284483 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
