2
System in Delphi - Database Firebird 2.5.
I have a server with 25 "files" of databases, one from each client. Each customer has on average 10 accesses via TS to connect to our server.
However, when the peak time comes around 4 pm, some banks are Offline and the system loses connection to it.
There is a way to configure Firebird to limit connections to the database?
1
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 Superclass version up to version 2.5.2 ( Windows OS ) 1024 connections. In newer versions has been extended to 2048 connections.
I suggest that for each database you install a running Firebird process, and each one on a different port. Port settings can be modified in the Firebird.conf file in the installation directory.
I recommend you sign up for the firebase portal, there are many articles and tips for the community that uses Firebird.
1
There are no connection limits in 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 usually works via xinetd or inetd which have their own configuration and access control. So it is necessary to check the settings, especially in the case of using a terminal service.Reading suggestion
Since a 32-bit process has a RAM limit that it can allocate, the Superserver version of Firebird will have a connection limit.
Browser other questions tagged database firebird connection firebird-2.5
You are not signed in. Login or sign up in order to post.