MySQL Forums
Forum List  »  Connector/ODBC

Re: MySQL ODBC slow driver with windows 10
Posted by: Bogdan Degtyariov
Date: October 22, 2018 12:20AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: MySQL ODBC slow driver with windows 10
October 22, 2018 12:20AM


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.