Request timeout question

rubyonrails-talk
1

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

2

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

3

Could a separate thread be used?

4

Drb uses separate thread

5

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

Cheers, Sazima