更新时间: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