--- In firebird-support@yahoogroups.com, "Da Jiao" <dajiao0@h...>
wrote:

> Hello all,
>
> I am a newbie to Firebird. I am from SQL Server background but I am

planning to use Firebird for my next project. Could anybody tell me
what is the concurrent connection limitation for Firebird? I know
there is no formal limit but practically there got to have some
threshold that too many concurrent connections will drag down the
performance.

>
> Hope people with practical experience will share their experience

with me. Thanks in advance.

Da Jiao, IIRC hardcoded limit is 1K connections, but I can be wrong.
As Dmitry said, important is not amount of connections itself but what
they are doing. Since IB/FB SuperServer versions still don't support
SMP well, and systems oriented on very large amount of connections
should naturaly be carried by SMP machines, known (at least for me)
implementation of such a systems are based on Classic versions and
there we have limitations in face of required RAM. Largest among known
for me production systems supports 300 direct connections in real life
and was tested on 600. Usually in case of necessity to serve thousands
of connections technology of connections pool on 150-200 connections
in middleware is used.

Best regards,
Alexander.