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:278336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
