# Request timeout question

**URL:** <https://discuss.rubyonrails.org/t/request-timeout-question/21648>\
**Category:** rubyonrails-talk\
**Created:** [December 13, 2007, 5:15am UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648 "2007-12-13T05:15:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adrian1](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@Adrian1](https://discuss.rubyonrails.org/u/Adrian1)\
**Post date:** [December 13, 2007, 5:15am UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648/1 "2007-12-13T05:15:36Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bala\_Paranj](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@Bala\_Paranj](https://discuss.rubyonrails.org/u/Bala_Paranj)\
**Post date:** [December 13, 2007, 6:41am UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648/2 "2007-12-13T06:41:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Adrian1](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@Adrian1](https://discuss.rubyonrails.org/u/Adrian1)\
**Post date:** [December 13, 2007, 6:54am UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648/3 "2007-12-13T06:54:25Z")

</div>

Could a separate thread be used?

---

<div class="post-metadata">

**Author:** ![Bala\_Paranj](https://avatars.discourse-cdn.com/v4/letter/b/41988e/32.png) [@Bala\_Paranj](https://discuss.rubyonrails.org/u/Bala_Paranj)\
**Post date:** [December 13, 2007, 7:10am UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648/4 "2007-12-13T07:10:55Z")

</div>

Drb uses separate thread

---

<div class="post-metadata">

**Author:** ![Ricardo\_Sazima](https://avatars.discourse-cdn.com/v4/letter/r/a87d85/32.png) [@Ricardo\_Sazima](https://discuss.rubyonrails.org/u/Ricardo_Sazima)\
**Post date:** [December 13, 2007, 4:52pm UTC](https://discuss.rubyonrails.org/t/request-timeout-question/21648/5 "2007-12-13T16:52:11Z")

</div>

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

Cheers, Sazima
