| Subject | Re: [firebird-support] How to limit the number of concurrent users to a database |
|---|---|
| Author | Tupy... nambá |
| Post date | 2012-06-14T10:55:10Z |
Signore Fulvio Senore,
If the problem really is to limit the simultaneous connections, if after each query, you close the connection, this will by his self assure that the simultaneously connected users will be the minimum. And will bring other benefits, as minimizing net traffic.
As normally well planned queries and transactions in well managed servers don´t last more than a second, doesn´t matter how much applications and machines are connected to the db server, they will not stay connected much longer. And so, not many will be connected at the same time - and probablyat most of the time, you will have only one user really connected to the db server.
Ask your front-end applications developers, how they programm your applications. Or your software deliverers... Today is not considered a good practice having a connection open for more than the time needed to send a request and get the result back. And for this reason, many paid sql servers send servers by the number of simultaneos connections.
Best regards,
Roberto Camargo.
If the problem really is to limit the simultaneous connections, if after each query, you close the connection, this will by his self assure that the simultaneously connected users will be the minimum. And will bring other benefits, as minimizing net traffic.
As normally well planned queries and transactions in well managed servers don´t last more than a second, doesn´t matter how much applications and machines are connected to the db server, they will not stay connected much longer. And so, not many will be connected at the same time - and probablyat most of the time, you will have only one user really connected to the db server.
Ask your front-end applications developers, how they programm your applications. Or your software deliverers... Today is not considered a good practice having a connection open for more than the time needed to send a request and get the result back. And for this reason, many paid sql servers send servers by the number of simultaneos connections.
Best regards,
Roberto Camargo.
--- On Thu, 6/14/12, Michael Ludwig <milu71@...> wrote:
From: Michael Ludwig <milu71@...>
Subject: Re: [firebird-support] How to limit the number of concurrent users to a database
To: firebird-support@yahoogroups.com
Date: Thursday, June 14, 2012, 2:05 AM
Fulvio Senore schrieb am 13.06.2012 um 22:17 (+0200):
> My purpose is very simple. The users can install the program on any
> number of computers connected to a Firebird server, and I want to
> limit the number of simultaneous connections.
Do you control the server? If you don't it'll be difficult to enforce
anything anyway. But if you do you might investigate whether it's
possible to configure this at the network level, like with iptables
on Linux, or whatnot on Windows. Take a look here, I didn't do further
checks so I don't know whether it's possible or not:
https://www.google.com/search?q=iptables+limit+number+of+connections
Michael
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
[Non-text portions of this message have been removed]