super, glad it helped :-) On Thu, Aug 18, 2011 at 4:41 PM, Rick Root <[email protected]> wrote:
> > so, I got two suggestions from this thread that proved worthy.. > > #1 - someone asked about the need for the .toString() call - apparently, I > don't actually need this. I ran some tests without it and it worked and > speed things up. > > #2 - Someone suggested writing the whole record instead of one field at a > time. CsvWriter has a writeRecord() method that accepts an array, so I > modified the code to put the values into an array and then use that method > instead. > > I was able to improve the performance of an output of 20,000 records from > 21 seconds to around 12 seconds with these two changes. > > > <cfset ArrayClear(local.valuesArray)> > <cfloop from="1" to="#numFields#" index="i" step="1"> > <cfset ArrayAppend(local.valuesArray, > resultSet[fieldsArray[i]][resultSet.currentRow] )> > </cfloop> > <cfset fileOutput.writeRecord( local.valuesArray )> > > Thanks all! > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346837 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
