Subject | AW: [firebird-support] Maximum concurrent connections? |
---|---|
Author | Steffen Heil |
Post date | 2004-09-07T18:14:05Z |
Hi
Firebird database server running 3 databases and 200 concurrent connections?
Apart of the maximum number of Sockets, your tcp/ip-stack can handle, the
limits for concurrent firebird connections are only dependent on the average
activity on these connections. Running only a brief query every 30 minutes,
firebird should handle hundrets of connections with no problems.
So what are your clients doing? Doing too much, 2 connections might already
too much.
Only one thing to remember: MGA was not designed to have long-running
transactions. Try to hard commit as often as possible.
Regards,
Steffen
> Does anyone know what the suggested maximum number of concurrentconnections a Firebird server can handle? Has anyone successfully managed a
Firebird database server running 3 databases and 200 concurrent connections?
Apart of the maximum number of Sockets, your tcp/ip-stack can handle, the
limits for concurrent firebird connections are only dependent on the average
activity on these connections. Running only a brief query every 30 minutes,
firebird should handle hundrets of connections with no problems.
So what are your clients doing? Doing too much, 2 connections might already
too much.
Only one thing to remember: MGA was not designed to have long-running
transactions. Try to hard commit as often as possible.
Regards,
Steffen