Subject RE: [firebird-support] Connection overhead
Author Chad Z. Hower
:: With FB 1.5 SS, maybe the first connection might have a
:: slight delay, just waiting until security.fdb is loaded in

That's fine. My concern is subsequent ones. I know it will be slower than
non pooled - but so long as its reasonable. They system is not super high
volume, but could be requesting a few connectrions a second at peak times.

:: memory. And IIRC, security.fdb is supposed to stay in
:: memory until there is no more connections to Firebird. With
:: Classic, it could be different, since every connection is a

Im pretty sure we are running super server.

:: But, I didn't find any problems without connection pooling
:: when using Intraweb and a good amount of concurrent and/or
:: rapid sequential connections. The best way to find out is to
:: do your own load testing.

Our situation is a bit different than normal. We will later reenable
connection pooling, but some things need to be changed to work around the
side effect.