> Anyone have thoughts on general performance improvments when
> generating a LOT of output from ColdFusion? A user was trying to
> generate CSV output from a select from ColdFusion and it was
> taking forever. They were generating a line at a time to the
> file. So then they tried to generate it all in-memory and write
> it out once - again, very very slow. They ended up 'chunking' it
> up in 30k chunks of lines and that seemed to be the best.
>
> This is the latest server SP, on SPARC Solaris...
>
> Any thoughts, additional performance improvements, etc?
Schedule it, run it later, email them or send them a link
I have some files which our clients download which are hitting MB of data
and are all CSVs - we force them to login to a secure site and it shows a
list of available files for them to download (via a page display, not a
directory list)
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
