I'm not a seequel server person, but I'd imagine a DTS thingy or SP would be useful for this. In Oracle, I'd say an SP at least.
13k rows is a helluva lot of RAM in CF, eh? DK On 11/14/05, Tony <[EMAIL PROTECTED]> wrote: > hola peeps. > > when dealing with a large report, from sql server, how do you > as a best practice deal with getting it into a CSV file, elegantly > without the server timing out, and killing resources? > > i am using query2csv, which is ok, but the query takes nearly > four minutes to run, then whatever time the query2csv takes to > run, and all in all, it can lead to a bad user experience. > > any ideas will be mucho appreciated. > > -- > ....tony > > Tony Weeg > tonyweeg [at] gmail [dot] com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224116 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
