>>>>Check out the following tests
>>>>Testconnections2 returned 0.23 seconds, Testconnections3 returned 4.68 seconds, that's a factor of 20 slower. If there is any pooling done here, it's either not working for me, or it's kind of not very effective.
>>>>What am I missing?
>>>>

>>>>    Public Sub testConnections2()
>>>>        Dim cmd As New OleDbCommand
>>>>        Dim da As New OleDbDataAdapter(cmd)
>>>>        Dim conn As New OleDbConnection
>>>>        Dim dt As New DataTable
>>>>        conn.ConnectionString = My.Settings.b040_beConnectionString
>>>>        conn.Open()
>>>>        cmd.Connection = conn
>>>>        Dim n As Long
>>>>        Dim t As Date = Now
>>>>        For i As Integer = 1 To 100
>>>>            cmd.CommandText = "select Art_id from Artikel where Art_nr = '  125'"
>>>>            n = cmd.ExecuteScalar()
>>>>            cmd.CommandText = "select * from artikel where Art_Nr = '  125'"
>>>>            da.Fill(dt)
>>>>        Next
>>>>        Debug.Print((Now() - t).ToString)
>>>>    End Sub
>>>>    Public Sub testConnections3()
>>>>        Dim cmd As New OleDbCommand
>>>>        Dim da As New OleDbDataAdapter(cmd)
>>>>        Dim conn As New OleDbConnection
>>>>        Dim dt As New DataTable
>>>>        conn.ConnectionString = My.Settings.b040_beConnectionString
>>>>        cmd.Connection = conn
>>>>        Dim n As Long
>>>>        Dim t As Date = Now
>>>>        For i As Integer = 1 To 100
>>>>            conn.Open()
>>>>            cmd.CommandText = "select Art_id from Artikel where Art_nr = '  125'"
>>>>            n = cmd.ExecuteScalar()
>>>>            cmd.CommandText = "select * from artikel where Art_Nr = '  125'"
>>>>            da.Fill(dt)
>>>>            conn.Close()
>>>>        Next
>>>>        Debug.Print((Now() - t).ToString)
>>>>    End Sub
>>>>

>>>
>>>Look at it the other way:
>>>testConnection2 opened the connection once and took .23
>>>Assuming testConnection3 also took .23 the first time then the next 99 took only 4.45 i.e ~ .045 per connection = 5 times faster.
>>
>>
>>I think that if you take the code below out of the loop you'll have a better idea of the time conn.Open() takes after the first time
>>
>>testConnection2 = time to open once
>>testConnection3 = test to open a hundred times
>>
>>

>>>            cmd.CommandText = "select Art_id from Artikel where Art_nr = '  125'"
>>>            n = cmd.ExecuteScalar()
>>>            cmd.CommandText = "select * from artikel where Art_Nr = '  125'"
>>>            da.Fill(dt)
>>

>
>:-} :

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connectionString);
>
>           System.Diagnostics.Stopwatch sw = new System.Diagnostics.Stopwatch();
>           sw.Start();
>           conn.Open();
>           conn.Close();
>           Console.WriteLine(sw.ElapsedTicks);
>           for (int x = 0 ; x <1000; x++)
>           {
>               conn.Open();
>               conn.Close();
>           }
>           Console.WriteLine(sw.ElapsedTicks);

>1756136
>1919864


That's fast - including the answer

One open = 1756136 ticks

next 1000 = (1919864 - 1756136 ) / 1000 or 164 ticks per (re-)open