Re: MySQL ODBC slow driver with windows 10

[Bogdan Degtyariov]

Hi Roberto,

Unfortunately, I do not have enough information about how exactly your web site is working and what exactly has changed. After you installed Windows 10 the settings in IIS might have changed as well, which makes the configuration different from what you had in Windows 7.

I have a few recommendations what to check and how to improve the ODBC performance:

1. Check if the IIS application pool in Win10 is configured in the same way as in Win7.

2. ODBC Driver 8.0 might slow down because by default it is trying to use SSL encryption. Especially this can affect applications that establish a lot of short-living connections. The SSL handshakes and certificates exchange might take a significant part of the time if a connection is quickly opened/closed and this process repeats many times. You can try disabling SSL by specifying "SSLMODE=DISABLED" in the connection string or by selecting the DISABLED value in the ODBC Admin DSN Dialog (Details >> SSL >> SSL Mode)

3. ODBC Connection Pooling is a great option for the previous scenario. The application still opens and closes connections as before, but the driver manager "stores" an open connection in a pool to make it available for re-use upon request. This allows reducing the connecting time even if SSL is used.