Re: MySql.Data.MySqlClient is so SLOW?
Posted by: azherdev
Date: February 04, 2006 04:03AM

Can anyone let me know what the connection string would look like? That is not terribly dangerous because I do have multithreaded app. It is just that inserting 100 rows takes MS SQL Server 2000 0.32 seconds and the same exact way on MySQL 5.0 using MySql.Data 2.6 seconds. (same tables, same structure, InnoDB) So far, here is my connection string:

server=;user id=dev; password=dev; database=solfriends; pooling=true

What can I add or change to make this at least as fast as SQL Server. PS, both servers are running on the same box (Win2K). I've done dozens of tests, so far MySQL is about 8 - 10 times slower... :(

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.