Request timeout question

Hi All

I am trying to generate pdf reports/documents based on time consuming
database queries and associated calculations. When these are run in
development mode they work fine (apart from taking a long time
5-10mins) but when these are run on the production system they result
in timeout errors.

Is there a better way to approach this problem? The controller method
using the following statement:

send_data pdf.render, :filename => "financial_summary.pdf", :type =>
"application/pdf"

Any help appreciated.

Thanks
Adrian

You could use a cron job to run the reports periodically and send the
PDF files from the file system.

Background drb is another option

Could a separate thread be used?

Drb uses separate thread

If possible, generating the report in advance is the best option,
since the generation seems to be rally expensive (5-10min)...

Cheers, Sazima