Community Member Profile

Recent Blog Comments By Pete N.

• ColdFusion Optimizing Case Study: Writing Orders To A CSV File

  Posted on Jan 5, 2010 at 9:40 PM

  @Ben, If it wouldn't be such a waste of a damn-fine enlisted man I'd recommend you for OCS! You are gonna be a general someday!... (little forest gump reference in case ya didnt catch it) Seems balance is the way to go. I just generated a 1.25 million record csv file in about 55 seco... read more »

• ColdFusion Optimizing Case Study: Writing Orders To A CSV File

  Posted on Jan 5, 2010 at 1:34 PM

  Ben, Thanks for the quick reply! In the end, I may have to write to disk as you suggested. It's just so sad because the java stringbuffer performed so well. Then again, I can still use it to wrap up 20k or so records at a time, write to disk, repeat until done. Setting the ini... read more »

• ColdFusion Optimizing Case Study: Writing Orders To A CSV File

  Posted on Jan 4, 2010 at 10:00 PM

  Ben, It appears this is the correct format to set the SB initial size. <cfset sbOutput = CreateObject( "java", "java.lang.StringBuffer" ).Init(JavaCast("int",90000000)) /> However, this does not seem to help my problem. Thanks again in advance!!... read more »

• ColdFusion Optimizing Case Study: Writing Orders To A CSV File

  Posted on Jan 4, 2010 at 8:07 PM

  Ben, I have implemented this solution to create a csv which I am feeding to google AdWords Editor. Works like a champ! Once I build the csv file in memory, instead of writing to disk, I dump the results to the user and the user is prompted to save the file. However, once I get to ar... read more »