Re: mysql .net performance
Posted by: jacek.blaszczynski
Date: October 11, 2004 06:51AM

Hi Reggie!

The test was performed on the very same development hardware running MSDE and MySQL under WinXP SP1 fully patched - except SP2 (I leave it for a more thorughly tested status). Tables and test databases were created for the test purposes of this test only and are identical with respect to everything including indexes (actually there is one Primary Key over 1st column in both tables) , content (as You can see in code sample tables are empty at the moment for loop starts connecting, inserting row and disconnecting for exactly 500 to 10000 times in different test runs but everytime number of repetitions is equal for all tested connectors). The overall speed drops with increase in number of rows i.e number of for loop iterations (its slower with 10000 than with 500) but ratio of operations timing remains the very same.

I have not tested performance using other methods since I had no time to do that. Once my work will permit for that i will try to run such tests and will post results.

Hope this provides an answer to Your questions.

Anyway MySql Connector is a must have perspective for MySQL database and my hope is that it will provide competitive performance and acceptable level of conformace with SQL syntax and .NET architecture when compared to other connectors and in particular Oracle .NET Connector made by Oracle and MS SQL (SqlClient part of .NET).

Cheers

Jacek

Options: ReplyQuote


Subject
Written By
Posted
October 03, 2004 02:47AM
October 03, 2004 12:34PM
October 08, 2004 05:43AM
October 08, 2004 06:11AM
October 08, 2004 06:20AM
October 10, 2004 06:55PM
Re: mysql .net performance
October 11, 2004 06:51AM
October 11, 2004 07:09AM


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.