Hi all. Hoping someone who has "BEEN THERE, DONE THAT" can help.
Have to create a csv file from a cfquery resultset which can then be imported
into a number
of programs that do statistical analysis.
Approximately 5000 rows/records with a final size of 1730 kb.
A sql count and the display of the first 10 rows to screen is only a matter of
seconds.
Using CFFILE to covert query to CSV was VERY SLOW (intranet: approx. 1 min/1000
rows).
NOT ACCEPTIBLE.
Downloading the file to the client machine is a matter of seconds (approx 1
sec/1000 rows).
Using SQL and concatenating the fields per record, much, much faster.
Easier, in SQL SYBASE IQ12 is to add the following after the last clause in the
WHERE
statement: '> & newfile.txt'. The query WORKS in Interactive SQL, but when the
SQL statement
is wrapped in the <CFQUERY>, it BOMBS out. Can't read the > as a piping
command.
So....The question: what is the OPTIMAL process for generating the CSV file.
Any and all help would be appreciated.
Thanks, in advance,
Carol
Carol L. Bluestein
Senior Programmer
NYS Office of Real Property
518-486-6335
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
