What approach to follow for generating huge files on the fly?

[charmingsom]

Hi,

I am developing a application in JSF which has huge reports in pain text to be downloaded. The users who access these reports work in low bandwidth networks (<64kbps). We have to query the database tables(around 1million table entries would be fetched) and then make a report in plain text and then throw that file to the user for download. This must be done on the fly. Please let me know what is the data structures to be used and how can we approach so that performance is not hit and downloading and generation of report is faster.

Any code snippets would be really good.

Thanks,

Som

[ssilvert]

Hi Som,

This is not a JSF question, but rather a general java/development/software engineering question.  I suggest that you find a competent, experienced, software developer who can talk to you about your requirements and possible solutions.

Or, just find a more generalized board to ask your questions on.  I don't see anything particular to JSF in your question.

Stan