System in Delphi - Firebird database 2.5.
I have a server with 25 "files" of databases, one of each client. Each client has in average 10 accesses via TS to connect to our server.
However, when the peak time comes close to 4pm, some banks are Off-line and the system loses the connection with it.
Is there a way to configure Firebird to limit connections to the database?
According to the firebase portal ( link ) "depends on the architecture used (SuperServer, Classic, SuperClassic), OS, connection method (tcp / ip, xnet, etc.) and even the processing power of the hardware involved. "
In SuperServer and SuperClasse version up to version 2.5.2 (Windows OS) 1024 connections. In newer versions it has been extended to 2048 connections.
I suggest that for each database you instantiate a firebird process running, and each one on a different port. The port settings can be modified in the firebird.conf file in the installation directory.
I recommend that you subscribe to the firebase portal, there are many articles and tips for the firebird community.
There are no connection limits on Firebird itself. Still other factors may limit the number of connections allowed. See:
Most systems have a limit of 1024 simultaneous connections per TCP / IP port. To overcome this limitation you would need to create an n-tier system or connection pooling.
This mode generally works via xinetd or inetd that have their own configuration and access control. This is why it is necessary to check the settings, especially in the case of using a terminal service. Suggested reading
Since a 32-bit process has a limit of RAM it can allocate, Firebird's SuperServer version will have a connection limit.
