It's not often I nitpick in the sake of 'supreme optimization' but in
this case it's necessary. I'm using the following code snippet to
generate CSV file for different queries. The process is usually quite
memory intensive, wondering if anyone with fresh pair of eyes can point
out any items that can be done differently. Speed is not so much an
issue, it's quite fast...but for larger recordsets it eats mega RAM.
Thx! -Stace
<cfsetting enablecfoutputonly="yes" showdebugoutput="no">
<cfheader name="content-disposition" value="inline;
filename=#title#.csv">
<cfcontent type="text/x-excel-csv">
<cfoutput>#title##chr(10)##chr(10)##getData.columnlist##chr(10)#</cfoutp
ut>
<cfloop query="results">
<cfset x = 0>
<cfloop list="#results.ColumnList#" index="column">
<cfset x = x + 1>
<cfoutput>"#Replace( Evaluate( column ) , '"' , ' ' ,
'ALL' )#"<cfif x NEQ ListLen( results.ColumnList )>,</cfif></cfoutput>
</cfloop>
<cfoutput>#chr(10)#</cfoutput>
</cfloop>
</cfsetting>
AVIS IMPORTANT:
-------------------------------
Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.
WARNING:
-------------------------------
The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
