VS .NET and MySQL

[hekot]

Hi,

I'm currently developing a VS .NET application with C#. The program, run on Windows, needs to access MySQL which is installed on a linux machine (MySQL 4.0.15a & RedHat 7.2).

I connect MySQL thru ODBC (driver 3.51) and use C#'s system.data.odbc namespace to implement. And the program select about 700 rows from a 100,000 rows table.

However, the performance differs when I ran the same program on both Win2k and WinXP machines. The response is about 1 second for Win2k but about 10 seconds for WinXP.

Are there any VS .NET experts out there to solve this problem?
Thanks in advanced.


Peter

 

[obislavu]

1. The both machines W2K and WinXP are on the same network ?
2. Do you have the same settings for ODBC on the both machines ?
3. Do you have the same version of the .NET Framework on the both machines ?
4. Do you run the same .exe on the both machines ?
5. Are you sure there are no other tasks in background running (ativirus scan etc...) on one machine and no another one ?
6. Are you sure that no other processes are running on SQL when you query the DB ?
If you answer Yes to above questions then you should have the same response time.
-obislavu-

 

[chiph]

To add to obislavu's list:

How is the DNS configured on both machines? It sounds like a network look-up is timing out.

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first