Well, perhaps you answered your own question if you already understood the
benefit of pooling.

While firebird is quite good it all really depends on what type of
application you're using. If you're constantly making connections to it
(during loops or several connections within seconds) then of course, it's
going to be expensive, no matter how good the back-end is at handling it.
In my experience the application often creates more bottlenecks than the
database it sits atop.

Here's an article I found on the subject:

http://jaybirdwiki.firebirdsql.org/config/connection_pool.html

_____

From: Chad Z. Hower [mailto:chad-jm@...]
Sent: Friday, December 17, 2004 5:21 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Connection overhead


:: Connection-pooling is going to give you a significant boost
:: in speed/scalability in nearly any type of application,
:: though not absolutely necessary. There is considerable
:: overhead involved with creating a new connection upon each
:: request vs. grabbing an existing, pooled connection.

I know this is "general conventional wisdom". But not all DB's are the same
in this area. Does FB itself have significant overhead on connection
creation?



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129mbfclv/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705115386:HM/EXP=1103415692/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=493982218>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]