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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
