Subject | Maximum Number of Connections 2.5.3 |
---|---|
Author | |
Post date | 2015-06-02T00:51:55Z |
There seems to be contradictory information about maximum number of simultaneous distinct user connections to Firebird. This document:
How many users can connect to Firebird simultaneously? says there is not limit, except for the TCP/IP in the OS.
Firebird: The true open source database for Windows, Linux, Mac OS X and more
How many users can connect to Firebird simultaneously? says there is not limit, except for the TCP/IP in the OS.
However, on the download page of the Firebird home, it clearly lists the max number as fixed at : 2048
Firebird: The true open source database for Windows, Linux, Mac OS X and more
My app is stateful, must remain open for up to eight hours, and each user is distinct, so connection pooling is probably not the answer. (Each individual user's connection must be kept separate from each other). I need to serve 7,000 users. Should I forget about using Firebird for this app, and move to MS SQL Server?