Re: MySQL 5.2 ODBC Driver is slow, needs to use 5.1 to be fast
Hi Mark,
You can try the following to improve the ODBC performance:
The MySQL Server 5.6 has Information_Schema database, which has problems with performance (MySQL Server 5.7 is much better in this respect).
Therefore, disabling use of Information_Schema (which is enabled by default in MyODBC 5.2) might help. To do so you should open the ODBC Administrator and edit the corresponding DSN. In the GUI dialog navigate to Details >> Metadata and tick the box for [x] Don't use Information_Schema for metadata. The same can be done by adding "NO_I_S=1" to the connection string.
Subject
Written By
Posted
December 20, 2018 10:49PM
Re: MySQL 5.2 ODBC Driver is slow, needs to use 5.1 to be fast
January 22, 2019 12:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.