yah it is dontcha know tw
On 11/14/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > 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:224117 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
