From: Date: August 3 2004 12:41am Subject: RE: WinXP MSACCESS migration to -> MySQL -ODBC extremly slow List-Archive: http://lists.mysql.com/win32/15310 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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]=20 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=20 <1sec using MS Access. (All SQL ODBC statements are the same as used for the Access version,=20 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=B4t use set locale" - was mentioned in this list, but = doesnt=20 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