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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
