且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

连接池如何工作?

更新时间:2023-11-13 17:53:34

在这里阅读 [ ^ ] MSDN解释非常好。


请参阅Ron Beyer提供的链接以及这些链接



ADO.NET连接池概览 [ ^ ]



ASP.NET中的连接池 [ ^ ]



问候..:)


阅读本文e $>


ADO-NET -101-SQL连接

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

<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 ..

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


Refer the link provided by Ron Beyer and also these ones

ADO.NET Connection Pooling at a Glance[^]

Connection Pooling in ASP.NET[^]

Regards..:)


Read this article

ADO-NET-101-SQL-Connection