连接池如何工作？ [英] how does connection pooling works?

问题描述

连接池的概念是什么？它是如何工作的？

连接字符串如下：

 <   connectionStrings  >  
 <   add     name   = 视频游戏    connectionString   = 数据源= 1.1.1.1;初始目录= DbVideogames;用户ID = sa;密码= 321;最小池大小= 5;最大池大小= 20;    providerName   =  System.Data.SqlClient  /  >  
 < span class =code-keyword><   / connectionStrings  >  

假设世界上有1000个用户试图建立与网站的连接（比如亚马逊），同时我们在池中只有20个连接，那么网站崩溃了吗？最大pool size = 20意味着同时只有20个用户可以连接到网站并进行交易？任何人都可以详细说明这个概念。 Thanx ..

解决方案

在这里阅读 [ ^ ] 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

这篇关于连接池如何工作？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！