I'd *really* be trying to get the DBMS to dump this file out. If that's completely out of the question, I'd look at cfexecute-ing some sort of batch query tool (not sure what this is for oracle - the mssql equivalent is bcp). As a last resort, maybe dropping into Java offers you something, but I really don't know what the options are here - maybe open a cursor?
Jaime Metcher > -----Original Message----- > From: Garth Young [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 25 July 2007 2:14 PM > To: CF-Talk > Subject: Re: Writing large data files > > > >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 > > > > > >> > > The problem I have is that the Coldfusion query is not returning > as the result set is too big. I could simply run the query > pulling out blocks of rows from it but this would require > re-executing the SQL 6-7 times at least. > > I suppose I could increase the JVM max memory to 2GB but I'm not > really sure if this is a viable option. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284499 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4