>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4