From: Brian Candler <B.Candler@...>
Date: 2003-07-02T22:45:08+09:00
Subject: Re: DBD::Oracle9 and non-blocking mode

On Wed, Jul 02, 2003 at 01:03:12PM +0900, KUBO Takehiro wrote:
> > However, I wasn't particularly happy with this approach, so in the end I
> > changed my application to run as multiple processes (in fact running under
> > FastCGI, so Apache controls the number of processes which are spawned), each
> > of which is a single thread so I don't care if OCI blocks.
> 
> Hmm. What approach you prefer?

It just seemed to work faster when I had five separate processes doing
Oracle queries, than one process with five threads. Also, using
Apache/Fastcgi gave me a ready-made mechanism for creating a pool of
processes and automatically restarting them if one fails. Using threads I'd
have to write my own thread manager to do that.

Cheers,

Brian.