MySQL Bugs: #3024: MyODBC-3.51 driver is extraordinarily slow

Bug #3024	MyODBC-3.51 driver is extraordinarily slow
Submitted:	1 Mar 2004 9:07	Modified:	31 May 2013 8:12
Reporter:	Bruce Gregoire	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
What Happened: I used the ODBC 3.51 driver to link MS Access 2003 to MySQL tables.  Then I ran a batch process for 400,000 records that normally runs for 2 hours with other ODBC connections. 

What I expected to happen: I expected the process to take 2 hours or less.

What did happen: The process took 12 hours.  For some reason the ODBC drivers seemed to slow down the process tremendously. 

Does anyone have any idea why this took so long?

Thanks

Bruce Gregoire, President
DMSI
Falls Church, VA
(703) 941-8109
www.DesktopMarketingInc.com
DesktopMrk@aol.com

How to repeat:
You can repeat this bug by running a batch process with 400,000 records linked to Access2003

Indeed we have already verified this behavior with XP SP1 and MyODBC
the reason found is that the SP1 introduced modifications that when
the driver calls setlocale for every record. The solution found is
to set the MyODBC flag for not to use setlocale and delete all the
Access linked tables, close Access/Open again and re-link the tables
again.

Thank you for your bug report. This issue has already been fixed in the release version of that product, which you can download at

  http://www.mysql.com/downloads/connector/odbc