MySql.Data.MySqlClient is so SLOW?

[Denis Volovik]

Dear developers,

I use the MySql.Data.MySqlClient (MySql Connector .NET) in a ASP.NET project.
The web application hosted on a Windows Server 2003 machine uses a MySql database hosted on a remote Linux machine... Unfortunately the connection
the connection is so slow that I simply cannot use this connector in my project.

On a test page which does 20 connections to the remote server at a time - it takes 50-70 seconds per 20 connections...

After spending some time I've decided to try alternatives and tried the - CoreLab MySQLDirect .NET - (trial) connector... I was amazed to see that what before was 50-70 seconds has turned into 400 milliseconds per 20 connections...

While it might sound as an advertisement to the CoreLab connector :) - It is only to show that it IS possible to make faster connections... [Unfortunately I will not be able to use the CoreLab connector in my current project since it was not initially included in the project budget..]

Am I missing something? Does the MySql.Data.MySqlClient connector really work so slow? or is there a chance to improve it's performance by a proper configuration or something?

Please help!