how does connection pooling works?

Question

0.00/5 (No votes)

See more:

what is the concept of connection pooling? How it works?
A connection string is as follows:

XML

<connectionStrings>
        <add name="videogames" connectionString="Data Source=1.1.1.1;Initial Catalog=DbVideogames;User ID=sa;Password=321;Min Pool Size=5;Max Pool Size=20;" providerName="System.Data.SqlClient"/>
    </connectionStrings>

So suppose 1000 users throught the world attempts to make connections to a website(Lets say Amazon) at the same time we can have only 20 connections in pool so do the site crash? Does max. pool size= 20 means at the same time only 20 users will be able to connect to website and make transactions? Can anyone please elaborate the concept.? Thanx ..

Posted 18-Aug-13 19:32pm

Rambo_Raja

Add a Solution

4 solutions

Solution 1

Take a read here[^] MSDN explains it pretty well.

Posted 18-Aug-13 19:33pm

Ron Beyer

Comments

Thanks7872 19-Aug-13 1:49am

Very good link. ↑voted.

Rakshith Kumar 12-Nov-13 4:56am

Good one 5+ :)

Solution 2

Refer the link provided by Ron Beyer and also these ones

ADO.NET Connection Pooling at a Glance[^]

Connection Pooling in ASP.NET[^]

Regards..:)

Posted 18-Aug-13 19:52pm

Thanks7872

Solution 3

Read this article

ADO-NET-101-SQL-Connection

Posted 18-Aug-13 19:58pm

Dineshshp

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rambo_Raja · Accepted Answer · 2013-08-19T02:05:00

There can be maximum 32767 connections to the database at a time that is at a single point of time only 32767 users can make transactions to database via web app. Not even a single one more than that. A pool size is not mentioned anywhere(I have invested 2 days in researching it) only default is there(100). But Sequel server will only accept 32767 simultaneous connections from user. Proof: Select @@MAX_CONNECTIONS . If misunderstood please correct me. Thanx...