MySQL Bugs: #7112: Connector/NET running at half speed of ByteFX

Bug #7112	Connector/NET running at half speed of ByteFX
Submitted:	8 Dec 2004 17:46	Modified:	9 Dec 2004 22:53
Reporter:	Chris Sigrist	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	1.0.2	OS:	Windows (Windows Server 2003)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
In the process of trying to debug another issue I am having with Connector/NET, I set up a very simple speed test.

Using: MySQL v4.1.7  

I have a routine that is cycling through a simple database select call x times.  Nothing fancy, it queries the the DB with the following sql statement:

"SELECT * FROM tbl_ad_server WHERE ad_publish = 1 AND (ad_impressions <= ad_max_impressions) ORDER BY ad_temp_impressions ASC LIMIT 0,1"

It then opens a datareader and iterates through the single returned record.

Using <%@ Import Namespace="MySQL.Data.MySQLClient" %> at the top of my page, 8000 db calls take approx. 20 seconds on my server (Dual HyperThreaded 3.0 GHz XEON with 3GB Ram, SATA RAID)

Changing nothing else but the dll reference, to:
<%@ Import Namespace="ByteFX.Data.MySQLClient" %>, the same 8000 cycles only takes 12.5 seconds. (This is using ByteFX v0.7.6.15073).  Obviously, I have both the ByteFX and Connector/Net dlls in my bin folder.

What is going on here?  It seems that the newer version has actually lost perfomance.

How to repeat:
Try it yourself.  It's just a select statement.

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Chris

Since this is part of a web app you are making, there are several things that could produce this behavior.

I have a test case here that pushes 500 records out to a *VERY* remote server and then reads those records back in using a reader.  I tested this app using ByteFX 0.76 and got an average of 47seconds over 3 runs.  The same app with 1.0.2 gamma gets an average of 45 seconds over 3 runs.  

Perhaps you can test a winform app or further isolate your test to make sure it is the code causing the problem.