Hi,
I’m using FastCGI with a web application that occasionally has to make
slow (a few seconds) MySQL queries. With only one Ruby Thread acceptng
connections all other requests are blocked by such a query; the solution
could be to start multiple ruby processes, but this is a waste of memory
(Amrita requires huge amounts); so I think it would be the best solution
to use Ruby threads. Is that possible? Or do you have any other
suggestions?
Thanks
Andreas
Hello Andreas,
Thursday, March 18, 2004, 3:29:36 PM, you wrote:
Hi,
I'm using FastCGI with a web application that occasionally has to make
slow (a few seconds) MySQL queries. With only one Ruby Thread acceptng
connections all other requests are blocked by such a query; the solution
could be to start multiple ruby processes, but this is a waste of memory
(Amrita requires huge amounts); so I think it would be the best solution
to use Ruby threads. Is that possible? Or do you have any other
suggestions?
They also block. The MySQL client library has a blocking API.
Wait until we get native threads in ruby or use multiple ruby
processes.
--
Best regards,
Lothar mailto:mailinglists@scriptolutions.com