using System;
using System.Data;
using System.Data.SqlClient;
namespace ConnectionPooling
{
class MainClass
{
public static void Main()
{
SqlConnection cnt = new SqlConnection(
"server=someServer; database=Northwind; uid=sa; pwd=sa; " +
"min pool size=5; max pool size=10");
// open the SqlConnection object 10 times
for (int count = 1; count <= 10; count++)
{
Console.Write("Connection count = " + count + ", ");
DateTime startTime = DateTime.Now;
cnt.Open();
TimeSpan timeTaken = DateTime.Now - startTime;
Console.Write("Milliseconds = " + timeTaken.Milliseconds + ", ");
Console.WriteLine("cnt.State = " + cnt.State);
cnt.Close();
}
Console.ReadLine();
}
}
}
Main Points
1. Connection pooling offers a greate performane improvement.
2. When you close a connection, that connection isn't actually closed but marked as unused and stored in the pool, ready to be used again.
3. Default pooling size is from 0 to 100.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/782823/viewspace-366414/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/782823/viewspace-366414/