It is good practice to only have an open connection to the DB when you need to access or update data. So you have to design your application to, when a request from client is received:
- create and open a connection to the DB (this usually comes from the connection pool)
- select the data your need
- update the data
- close the connection and return it to the pool
It's a bad idea to keep DB connection permanently open while your app is open. In this way your connection is open for a very short period of time and you can service many user requests with a relatively small number of simultaneous open connections to the DB
Louis
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 27 October 2016 04:12 PM
To: firebird-support@yahoogroups.com
Subject: Re: {Disarmed} Re: [firebird-support] Number of concurrent user connections
> I was looking on FaceBook 'sDATA storage and MySQL !!!
>
> For sure millions simultaneous Users connected !!!
I would guess nobody is running an database server with millions of
connections simultaneously open.
On huge Systems as Facebook there are some application servers between
users and database which do serialize database access to an lower number
of connections - it does not make sense to let DB server process
millions of queries simultaneously since the hardware has not that much
parallelity.
Elmar
[Non-text portions of this message have been removed]
Posted by: "Louis van Alphen" <louis@nucleo.co.za>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (13) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment