From: estebanjang@...
Date: 2007-11-07T05:30:02+09:00
Subject: Long running SQL query via ActiveRecord blocking the entire Ruby process?


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?

[Ruby version 1.8.4, ActiveRecord version 1.14.4 on Linux]

-Steve