Subject RE: [firebird-support] FB Processes in Windows Classic 1.5.2
Author Simon Carter
> -----Original Message-----
> > What connection pooling options are you specifying in the
> connection
> > string?
>
> Pooling is switched on.

Could the pooling option be keeping the connection open longer than you
need? Try removing the pooling options and see if it improves.

> I'd really like to get a general understanding of why/when
> these processes start and die. So far, it seems there is one "master"
> process that's always running, and other processes that come
> and go. We spend a lot of time killing them manually when we
> need exclusive access to the database :-(

The master process, AFAIU, is always on, this monitors the port for
connections. Each connection then spawns a new process. I suppose the one
other thing that could affect how long the spawned process remains is
ConnectionTimeout in firebird.conf. Might be worth altering this setting
to see what happens.

Hih

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.net/