I've also made a lot of changes recently to take advantage of this. Here's a simple test and result to show the differences I've seen.
The query returns 21,596 records. [49407ms] /CFStringAppend/ [468ms] /javaStringBuffer/ // With this code: <cfset stringBuffer = CreateObject( "java", "java.lang.StringBuffer" ).Init() /> <cfquery name="noms" datasource="#request.dsn#"> Select ID From nomination </cfquery> <cfset mystring = ""> <cftimer label="CFStringAppend"> <cfloop query="noms"> <cfset mystring = mystring & "this is row: " & noms.CurrentRow & "<br />" /> </cfloop> </cftimer> <cftimer label="javaStringBuffer"> <cfloop query="noms"> <cfset stringBuffer.Append( "this is row: " & noms.CurrentRow & "<br />") /> </cfloop> </cftimer> <cfoutput> #stringBuffer.ToString()# <hr> #mystring# </cfoutput> More than 100 times better. That's quite a significant difference, isn't it??? ***************** Ken Ferguson 214.636.6126 ***************** Rob Wilkerson wrote: > I'll second Ben's recommendation. I changed several of my large > string concatenations and saw performance increases up to 90% over the > traditional method. It really makes a huge difference. > > On 6/20/06, Ben Nadel <[EMAIL PROTECTED]> wrote: > >> If you are building a massive string (without appending to a file) I would >> suggest using the Java StringBuffer. It creates parts of a string and then >> creates a full string once at the end... HUGE performance advantage over >> traditional string concatenation: >> >> <cfset jstrBuffer = CreateObject( "java", "java.lang.StringBuffer" ).Init() >> /> >> >> <cfloop query="qTest"> >> <cfset jstrBuffer.Append( "this is row: " & qTest.CurrentRow ) /> >> </cfloop> >> >> <cfoutput> >> #jstrBuffer.ToString()# >> </cfoutput> >> >> ....................... >> Ben Nadel >> www.bennadel.com >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, June 20, 2006 1:41 PM >> To: CF-Talk >> Subject: Export text >> >> I need to do a simple download of 100,000 plus records out of SQL. I would >> like the user to get prompted to save a .txt file They will be using recent >> versions of IE. I've been playing around with CFHeader and CFContent. It >> works OK if specify Application/msexcel. Does anyone have any code examples >> dumping to a text file? >> >> Lee >> >> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54