using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Diagnostics;
namespace _02ConnectionpoolTest
{
class Program
{
static void Main(string[] args)
{
string connStrPool = @"server=.;Database
=Test;User Id=sa;Password=sa123;Pooling=True;Min pool Size=4;";
string connStr = @"Data source=.;Database
=Test;User Id=sa;Password=sa123;Pooling=False";
int i = 0;
Stopwatch sw = new Stopwatch();
sw.Start();
while (i<1000)
{
using (SqlConnection conn = new SqlConnection(connStrPool))
{
conn.Open();
}
i++;
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Seconds);
sw.Reset();
sw.Restart();
i = 0;
while (i < 1000)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
}
i++;
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Seconds);
Console.ReadKey();
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Diagnostics;
namespace _02ConnectionpoolTest
{
class Program
{
static void Main(string[] args)
{
string connStrPool = @"server=.;Database
=Test;User Id=sa;Password=sa123;Pooling=True;Min pool Size=4;";
string connStr = @"Data source=.;Database
=Test;User Id=sa;Password=sa123;Pooling=False";
int i = 0;
Stopwatch sw = new Stopwatch();
sw.Start();
while (i<1000)
{
using (SqlConnection conn = new SqlConnection(connStrPool))
{
conn.Open();
}
i++;
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Seconds);
sw.Reset();
sw.Restart();
i = 0;
while (i < 1000)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
}
i++;
}
sw.Stop();
Console.WriteLine(sw.Elapsed.Seconds);
Console.ReadKey();