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=10.30.78.100;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... :(
Subject
Written By
Posted
September 02, 2005 05:25PM
November 19, 2005 12:47AM
November 29, 2005 08:56AM
November 29, 2005 12:57PM
December 04, 2005 02:50PM
December 15, 2006 06:59AM
Re: MySql.Data.MySqlClient is so SLOW?
February 04, 2006 04:03AM
February 04, 2006 10:50AM
February 04, 2006 06:16PM
February 04, 2006 06:51PM
February 07, 2006 07:43AM
February 05, 2006 11:30PM
February 06, 2006 03:26PM
February 07, 2006 07:28AM
September 09, 2006 07:36PM
September 19, 2006 05:15AM
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.