Well these are rough estimates, and your server performance may vary - but in my testing, a recordset with about 20 fields, and just under 3000 records, the file that ran this through CSVFormat (among some other functions beforehand, which take up part of the total) ran around 35 seconds.
But the server I'm running this on (our dev server) isn't the hardest-hitting box out there, either. Your mileage may vary. ----- Original Message ----- From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 12:25 PM Subject: Re: Turning a query recordset into a comma-delimited string/file > How well would the CSVFormat function work on a 20,.0000 result recordset > with, say 10 fields? > > Any ideas? I have been using the Query2Excel Custom tag and it is way to > slow for this size of operation. I hope this is better! ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
