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
