But surely you would not have all 7000 connections open at the same time all the time? That is bad practice. Connection should only be open for the duration of the interaction with the DB. After a query it should be closed and disposed. Then it is unlikely that you would need 7000 connections for 7000 users. Depends on the frequency of interaction





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 02 June 2015 04:26 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Maximum Number of Connections 2.5.3





Hi Dmitry, thank you for your answer. For may DB connection to FB, I'm using TIBCConnection (IBDAC) (Specifically for Firebird) by DevArt. In the documentation, it talks about connection pooling, and says that a connection will only be re-used if all the parameters are the same between a requested new connection and an existing connection, including username and password. With 7000 distinct users, how can connection pooling help in this situation? Wouldn't I need 7,000 connections. I don't see how pooling will help.

Alternatively... I could just not pool my connections, and just use Classic and that would solve the problem, is that correct?





[Non-text portions of this message have been removed]