handling a large data

[Nanda]

I have to write a large amount of data (approx millions of records)(reading from Oracle db) to a file, which can be downloaded by client later. I am looking for some suggestions considering, performance, timeout and file format to be used etc...How you all will solve this?

Thanks