Best bet is don't do it in ColdFusion at all, let the SQL engine do the work and ref the resultant file.
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Tony To: CF-Talk Sent: Wed May 16 20:27:50 2007 Subject: Dealing with Large queries and csv files hi there. when dealing with record sets in the 10,000 records plus arena how do you, in the fastest way possible, get that record set into comma delimited format, and subsequently write that out to a file? i have a nice little test bed setup, that i can see very the bottlenecks in doing this. getting the data takes less than 2 seconds taking the data from a query object to a csv formatted object takes too long writing it to a file takes no time at all maybe a second or two and the rest is willy nilly... its just the process of query object to csv formatted object, that is the problem... how/what do you all do? btw, im currently using the UDF (QueryToCsvSpecificRows()) thanks! tony -- 'Never have anything in your life that you can't walk out on in thirty seconds flat, if you spot the heat coming around the corner' robert deniro - heat (1995) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278329 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4