File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Joined: May 09, 2007
May 10, 2007 00:59:00
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
Joined: Jul 17, 2006
May 10, 2007 11:46:00
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.
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.
I agree. Here's the link:
subject: Connectionpool Configurations
Maintaining scalability in servlets programming
Stale Connection Exception
[Struts] DataSource ... ConnectionPool
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015