whoops, didn't see the other posts. You could create a SQL server integration services package. This could then be executed from a stored procedure that your CF code could call. (supposing that CF needs to do something with the file afterwards).
On 5/16/07, Wesley Middendorff <[EMAIL PROTECTED]> wrote: > > If you database server has access to a file system that your CF server > also has access to, you could try using the export functions built into your > DB server. I usually try to keep data processing in the DB server since it > is way more efficient at it. > > Wes > > > On 5/16/07, Tony <[EMAIL PROTECTED]> wrote: > > > > 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) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
