LabVIEW
MySQL very slow on Win 2000 Fast on Win XP Found a fix
Greetings,
I've recently rolled out an internal LabVIEW 8.5 application that works with a MySQL database. Several of the PCs required an installer. Although a few of them belonged to other LabVIEW developers in the office and required only the .exe file to run.
After setting up the OBDC connector, the application works on all the PCs. However, any calls to the database are brutally slow on the one Windows 2000 machine.
I thought perhaps the problem might be due to the fact that the LabVIEW program was compiled on a Windows XP machine. But even when I run the connection test from the OBDC Data Source Configuration dialog, it responds much slower on the Windows 2000 machine than any of the Windows XP machines.
-------edit---------
While in the middle of drafting this post I happened upon some information on the MySQL forums.
Adding the following lines to the "my.ini" file in the MySQL Server 5.1 directory cleared the problem right up.
skip-host-cache
skip-name-resolve
All my clients are working fine now. Let the weekend begin!
I've recently rolled out an internal LabVIEW 8.5 application that works with a MySQL database. Several of the PCs required an installer. Although a few of them belonged to other LabVIEW developers in the office and required only the .exe file to run.
After setting up the OBDC connector, the application works on all the PCs. However, any calls to the database are brutally slow on the one Windows 2000 machine.
I thought perhaps the problem might be due to the fact that the LabVIEW program was compiled on a Windows XP machine. But even when I run the connection test from the OBDC Data Source Configuration dialog, it responds much slower on the Windows 2000 machine than any of the Windows XP machines.
-------edit---------
While in the middle of drafting this post I happened upon some information on the MySQL forums.
Adding the following lines to the "my.ini" file in the MySQL Server 5.1 directory cleared the problem right up.
skip-host-cache
skip-name-resolve
All my clients are working fine now. Let the weekend begin!
