This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes Connectionpool Configurations Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connectionpool Configurations" Watch "Connectionpool Configurations" New topic
Author

Connectionpool Configurations

Reeta Champs
Greenhorn

Joined: May 09, 2007
Posts: 5
Hi

In connectionpool configuration, How to calculate the min, max connections in pool. Also if we give maxpool=30, does that means that at any point of time only 30 people can connect to the website?

How can thousands of users will access the website concurrently if the max pool size is only 30?

Thanks In advance
Reeta
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
hi Reeta,

No, it does not mean that only 30 people can connect to your website
(but a lot more).

It means that you can have 30 connections at the same time to your database.

An example:
If your average SQL-query takes 0.5 seconds, you can do about 60 queries per second. If the average user does 1 SQL-query per 10 seconds, you can handle about 600 users at the same time.

Herman
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connectionpool Configurations