Hi,

I have following questions.

1. Suppose I have 1000 concurrent users for my application should i set connection.pool_size property as 1000?
2. I mean to say does the size of connection pool equals no of concurrent users?
3. Is there any limit to the property connection.pool_size?
4. If I am using c3p0 what decides the minimum no of connections?

Thanks in advance.

Regards,
Shomit

Our JBoss has a pool of three up to ten connections under normal conditions. Under really heavy load there are 15 or so. Thats enough to handle around 100 users. But it depends on what our users are doing. Our users do typical office stuff... They have paper, they type some form data. Two to twenty fields on each page and then save and read the next page. The number of connections you need grows if there are many "real" parallel actions and how long each transaction takes. If "saving" means "Load old data, validate new data against it, write alot and read again" then you need more connections - our your users have to wait if a connection is available again.

The max size of the pool depends on what your DB can answer. If your database server doesn't react fast enough or is under heavy load all the time, then it's useless to open ten, twenty, hundred connections on top. There will be no performance boost.