mySQL pooling with mySQL 5.5.30 and ODBC 5.2

[Ali Alama]

Hello,

I want to use the pooling option in order to speed up the connexions to the mySQL server.

So I used this connection string in VB.Net

Public Cnx As New OdbcConnection("Driver={MySQL ODBC 5.2 ANSI Driver};Server=localhost;Port=3306;Database=mybase;User=root;Password=pwd;Option=3;pooling=true;")

But unfortunately it's the same time for opening a connection as if I set Pooling to false.

(1000 ms) each time

I was used to 1 ms with mysql 5.1.34 and ODBC 3.51


So please, is this the right connection string ?

Regards