RE: WinXP MSACCESS migration to -> MySQL -ODBC extremly slow

[jbonnett]

I presume you are running this join from C++. Do you have all the same
indexes, or at least the ones relevant to the join, as in the Access
situation. Access often helpfully creates extra indexes for you without
asking.

My experience is that MySQL usually easily outruns Access though I have to
admit there are often situations where Access does an unexpectedly good job.

One suggestion, do you need to use ODBC with C++? Couldn't you use
libmysql.dll directly?

John Bonnett

-----Original Message-----
From: spambox [mailto:thespam@stripped] 
Sent: Monday, 2 August 2004 11:34 PM
To: win32@stripped
Subject: WinXP MSACCESS migration to -> MySQL -ODBC extremly slow


I`ve migrated from MS Access to MySQL using VC++ 6.0 and MyODBC.

But a select * from a join of 3 Tables takes about 6 sec. compared to 
<1sec using MS Access.
(All SQL ODBC statements are the same as used for the Access version, 
database tabeles were copied 1:1  )
Im working on a single PC as local admin.
steps done:
- using snapshot instead of dynaset (to avoid a total crash)
- switches set in ODBC driver: ( MySQL ODBC 3.51 Driver DSN )
   X) "Don´t use set locale"  - was mentioned in this list, but doesnt 
help
   _) all other switches not set !
Version: mySQL 4.0.20a-nt, Port 3306
DLL used: myodbc3.dll (not the debug version)
Any idea ? thx , Roland