Connection Pool

[Guest]

Hello,

Is it ado provider by default do the connection pooling? or it is depending
on the database. I know sqlclient provider does the connection pooling but
can I use connection pooling with MYSQL?


thanks
ap

 

[Paul Clement]

¤ Hello,
¤
¤ Is it ado provider by default do the connection pooling? or it is depending
¤ on the database. I know sqlclient provider does the connection pooling but
¤ can I use connection pooling with MYSQL?
¤

Connection pooling is enabled by default unless the data provider does not support the feature.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Miha Markic [MVP C#]]

Hello,

Is it ado provider by default do the connection pooling? or it is
depending
on the database. I know sqlclient provider does the connection pooling
but
can I use connection pooling with MYSQL?

With native provider? If provider supports it then yes, otherwise not -
depends on provider.

 

[Sahil Malik]

This is implemented in the provider - and is provider specific. SqlClient
does it by default - unless you disable it. That is the default behavior in
99% of the cases.

For more info please see --
http://dotnetjunkies.com/WebLog/sahilmalik/archive/2004/11/12/31798.aspx

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik