Slow performance using mysql 5.3 odbc driver on windows 2008 machine

[Prathiba K]

Hi All,

Third party vendor provides us the data as MySQL database. We use SQL Server and using linked server to MySQL, we get the data.

This was our configuration before:
Sql server Database server: Window 2003 (32 bit), MySql ODBC driver 3.51.16 (32 bit), MySql database 5.1

Now we moved to Windows 2008 (64 bit), MySql ODBC driver 5.3 (64 bit), MySql database 5.1

But the Queries that used linked server to query mySql performance has gone down drastically. It is 3 to 4 times slower. We are not sure why.

Trouble shoot:

1) We wanted to see how it works on Windows 7 machine. So, we installed 5.3 64 bit odbc driver and tried. Performance was very slow.
2)We uninstalled 5.3 version and tried to install 3.51.16 (our original) version. It didn't even install. We had errors.
3)Next, we downloaded 3.51.30 (64 bit) version, installed it. Successfully installed. When we created DSN and tested the connection, it gave error.
I tried many forums to see if anyone has issues like this, but couldn't find any. why is 3.51.16 not getting installed on windows 7 or windows 2008 (64 bit version) machine. Why is latest version 5.3 ODBC connector is giving slow performance. Our DBA did various benchmarks on new dev, test and prod servers.

I appreciate your response.
Thanks,
Prathiba