ok. next question. how in the heeeeeeeck do i do it in SQL? im using sql server 2000. i could use sql server 2005.
any and ALL HELP is appreciated. thanks tony On 5/16/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > 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) > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
