hi list. I have a question about writing csv files, record sets and which way would be the best to handle something like this....
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. I am currently just doing the query, writing the data and emailing the csv file 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? 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
