Chris Ditty wrote: > Thanks man. I'll pass this on to the person doing the coding. It > looks interesting.
Have you tested just SQL and CFML without all the Java stuff? The following code writes 1 million records within 10 seconds on a laptop that runs the database server at the same time: <cfquery name="bigQuery" datasource="pg_scorpio"> SELECT ID || ',''' || string || '''' AS row FROM memtest </cfquery> <cffile action="write" file="d:\test.csv" output="#valueList(bigQuery.row, chr(10))#"> CF may surprise you :) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265066 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
