From: snacktime <snacktime@...>
Date: 2007-11-07T08:01:41+09:00
Subject: Re: Long running SQL query via ActiveRecord blocking the entire Ruby process?

On Nov 6, 2007 12:30 PM,  <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?
>

C extensions that block will block the whole process, as they
basically interrupt ruby's thread schedular while they are running.
Unless the extension is written with this in mind, which most are not.

Chris