Bug #10920 Queries slow even when Set Locale turned off on XP SP2

• Submitted: 27 May 2005 16:00
• Modified: 2 Jun 2005 7:27
• Reporter: Jay Paroline
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S1 (Critical)
• Version: MySQL - 4.024 myODBC - 3.51
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[27 May 2005 16:00] Jay Paroline

Description:
I have a simple table with 3 records in it. Doing a select * from table with ODBC is extremely slow, on the magnitude of 20 seconds or more.

Doing the same query with MySQLQueryBrowser is instantaneous.

I have turned off set locale as I found that bug already listed here, but the problem persists.

How to repeat:
CREATE TABLE `logins` (
  `username` varchar(20) NOT NULL default '',
  `pass` varchar(20) NOT NULL default '',
  `session_id` varchar(33) NOT NULL default '',
  `expires` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`username`,`pass`)
) TYPE=MyISAM;

create 1 or more records

use excel XP: Data | Import External Data | New Database Query
select the correct DSN.
set up a simple select * on the table

NOTE: I do not think this is actually related to the table in any way, because if you go to the ODBC connection properties and you test, it responds quickly that the server is working, but then takes another 20 seconds or so before the UI will respond again.

[27 May 2005 17:05] MySQL Verification Team

Yes this issue was already detected on XP. The work-around is to use
the MyODBC flag Don't Use set Locale. Please verify it in this way.

Thanks in advance.

[27 May 2005 17:10] MySQL Verification Team

Sorry I forgot to say you that I was unable to repeat the issue with
Access 2003. Just make sure if the flag is working,  for example
if you linked the table without the flag on and after you edited
the DSN it not takes effects if youn don't delete the older linked
table and doing it again (Access for example saved the original
string connection without the flag on).

[28 May 2005 15:59] Jay Paroline

Even after making a new excel spreadsheet after having turned off set locale, the problem persists.

[2 Jun 2005 7:27] Vasily Kishkin

I could't repeat the bug on Excel 2000. All data were inserted quickly.
Probably you need to upgrade software.

[2 Jun 2005 16:35] Jay Paroline

I have the latest office servicepack installed. What else can I upgrade?