From: Date: August 2 2004 4:04pm
Subject: WinXP MSACCESS migration to ->  MySQL -ODBC extremly slow
List-Archive: http://lists.mysql.com/win32/15296
Message-Id: <410E49E8.2020202@aon.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

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