jann. thank you for input, but since i posted it, i found my issue. it was something stupid in the code above the actual writing of the csv file...dumb mistake....looked like the beginning of a good idea, that i didnt finish cause i got yanked onto something else... forgot about it...and it was stalling everything...anyway, its all good now im doing 1500+ lines in like 20-25 seconds!!!
thanks tony! -----Original Message----- From: Jann VanOver [mailto:techinfo@;DragonflyGirl.com] Sent: Thursday, November 14, 2002 6:21 PM To: CF-Talk Subject: Re: cfmx/cfquery/writing csv files On 11/14/02 7:51 AM, "Tony Weeg" <[EMAIL PROTECTED]> wrote: > hi list. > . > A user makes a request for approximately 200 lines from an 11 million > record database. that > request is then written to a csv file, and emailed to the client. . > problem: the request for the query to write the csv file is timing out. > > question 1: does cf do the query, close the connection, write the csv > from a disconnected record set and then mail it? or is cf doing the > query, line by line, then writing each line to the csv file one at a > time? How are you creating the CSV? With CFM code? I have a CFX mod written in Java that gave me 1000% improvement when it came to writing large query sets to CSV. BUT are you saying that there are only 200 records in the query result set? PLEASE post your code -- you've got problems with your query or your DB indexing if writing 200 records is timing out. > > please help, also, do you have any suggestions on how to make this > slicker...my ideas.... > > 1. generate the recordset in cf > 2. invoke a webService, send the recordset to the webservice > 3. break this logic away from cf since what I am finding is that cf > doesn't do this very fast? > > please let me know what you think and what else others are doing in this > situation..... > > thanks! > > ..tony > > Tony Weeg > Senior Web Developer > Information System Design > Navtrak, Inc. > Fleet Management Solutions > www.navtrak.net > 410.548.2337 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
