Re: Writing large data files

I'm trying to look for something in java but I'm not familiar with the ins adn outs. I think the main problem is that I don't know the username and password (for the eventual production environment). Would I be able to somehow reuse the DSN used by ColdFusion to connect to the database?

Re: Writing large data files

I'm trying to look for something in java but I'm not familiar with the ins adn outs. I think the main problem is that I don't know the username and password (for the eventual production environment). Would I be able to somehow reuse the DSN used by ColdFusion to connect to the database?

Writing large data files

Hi, There have been previous posts about writing large data files from database queries and I have the same problem. The files I need to create may be up to 200-300MB in size (csv). I haven't tried in off-peak time but when I tried a large queries during normal hours it got a memory error.

Re: Writing large data files

I have released a UDF over at cflib.org, that will convert a ColdFusion query to CSV using JavaString Buffer which is considerably faster. http://www.cflib.org/udf.cfm?ID=1197 Thanks and let me know if you have any problem. Qasim The problem I have is that the Coldfusion query is not