From: Jeremy Kemper <jeremy@...>
Date: 2007-11-07T06:47:26+09:00
Subject: Re: Long running SQL query via ActiveRecord blocking the entire Ruby process?

On 11/6/07, estebanjang@gmail.com <estebanjang@gmail.com> wrote:
> To my surprise, a long running SQL query via ActiveRecord blocks an
> entire Ruby process (all the other threads are blocked while the
> thread that runs the SQL query is waiting for the result set)
>
> Has anyone else found this to be the case? (am I mistaken?)
> Is there any way to avoid this other than spawning a separate process?

The postgres and oracle adapters support async queries which won't
block Ruby threads, or you can use any of the pure-Ruby database
drivers.

Forking processes is probably better though.

jeremy