• Post Reply Bookmark Topic Watch Topic
  • New Topic

What Does DataSorce Manage Connections

 
ravisha andar
Ranch Hand
Posts: 55
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

How exactly does a datasorce manage connections.

Suppose i have configured a datasource with max connections 50.

What will happen if 51 users login concurrently?

How do I handle a concurrent login of 100 users ?

Do i have to set the maximum connections as 100?

Will it be a performance hit.

Please help me understand this?


Thanks

 
Scott Selikoff
author
Bartender
Posts: 4033
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If each user is holding a database connection, you've got a problem right there. Users should never "hold" database connections except for very specific types of applications. Connections in a pool are shared and swapped out all the time. Users may use 10 different distinct connections during their session without even knowing it.

The limit in your example is that a maximum of 50 concurrent processes can hold a connection at a given time. Any processes passed that will either wait or get an out of resource exception.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!