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? http://www.firebirdfaq.org/faq292/ says there is not limit, except for the TCP/IP in the OS. How many users can connect to Firebird simultaneously? http://www.firebirdfaq.org/faq292/ Collection of answers to questions about Firebird maximum, number, users, connections. View on www.firebirdfaq.org http://www.firebirdfaq.org/faq292/ Preview by Yahoo 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 http://www.firebirdsql.org/en/firebird-2-5-release-description/ http://www.firebirdsql.org/en/firebird-2-5-release-description/ Firebird: The true open source database for Windows, Lin... http://www.firebirdsql.org/en/firebird-2-5-release-description/ Firebird SQL: The true open-source relational database View on www.firebirdsql.org http://www.firebirdsql.org/en/firebird-2-5-release-description/ Preview by Yahoo 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?