About the number of connections to the database

0 like 0 dislike
6 views
There is a standard trehdverka: thin client — application server — DB. Clients 50. Is it true that for an acceptable response time between the server and DB will suffice, say, 5 connections?
by | 6 views

4 Answers

0 like 0 dislike
It all depends on how quickly the database will give data. And whether the application server is too long not to close the connection. It is necessary to take and measure. To answer this question "Yes" or "no" is impossible.
\r
Connection pooling is relevant *only* when the setting time a new connection is *really* needs to be reduced.
by
0 like 0 dislike
If the server opens for each request a new connection, I'm afraid there will be problems. If the server uses connection pooling keeps 5 connections and queries throws at him?
by
0 like 0 dislike
it all depends on the database and the client work with the server
by
0 like 0 dislike
If on mind all to do, really — we have five connections to the database sits 30 000 unique users per day. And don't complain.
by

Related questions

110,608 questions
257,186 answers
0 comments
1,119 users