MySql.Data.MySqlClient is so SLOW?
Posted by: Denis Volovik
Date: September 02, 2005 05:25PM

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!

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.