Subject | RE: [firebird-support] Connection overhead |
---|---|
Author | Chad Z. Hower |
Post date | 2004-12-18T15:52:26Z |
:: 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.
:: 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.