Bug #26172 MyODBC Server Side /Forward Only cursor test runs much slower with 5.0 drivers
Submitted: 8 Feb 2007 0:56 Modified: 7 Nov 2007 12:27
Reporter: Erica Moss Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:5.0.12 (2-07) OS:Windows (win xp)
Assigned to: Andrey Hristov CPU Architecture:Any

[8 Feb 2007 0:56] Erica Moss 
Description:
When ADO complience test rsmovenext.vbs is run under MyODBC 3.51, the TestExectuteValidClient() function takes 3.x seconds to complete.  The same test run under MyODBC 5.0 takes 23.x seconds to complete.

This test does the following:
Opens a record set with 100 records
moves forward to a random record
stores a random field
moves to the first record
moves back to the previous record
compares the stored field value to the current on
repeats 1000 times

How to repeat:
See ADO compliance test script rsmovenext.vbs

Either set two environment variables, "%CONN351%" and "%CONN5%" for 3.51 and 5.0 connection strings, or just hard code those strings in /common/mysql-common.inc

Pick which connstring to use in mysql-common.inc
Select the version number for myodbcV in mysql-common.inc

Run the script in the Script Unit framework
[8 Feb 2007 14:22] Bogdan Degtyariov 
Eric,

thank you for your bug report.
As I couldn't find rsmovenext.vbs on my machine, please attach it to the current report so I could check this script with both MyODBC 3.51 and 5.0.
[26 Oct 2007 13:38] Susanne Ebrecht 
Eric,

please try it with our new version MyODBC 5.1 and let us know, if the error still occurs.

Susanne
[31 Oct 2007 21:37] Erica Moss 
Retested with MyODBC 5.1  The runtime of this test case is comparable to MyODBC 3.51.20
[7 Nov 2007 12:27] Susanne Ebrecht 
Eric,

because this won't occur on MyODBC v5.1, I'll close this bug.

Many thanks for your help,

Susanne