I just installed MySQL 4.1.10 on a Win 2K server SP4. Using the MySQL Administrator and MySQL Query Browsers on the server works well and response is nearly instantaneous.
Using the same utilities from a workstation is very different. The results take 15-20 sec to appear.
I think the problem has to do with communication between the workstation and the server. Running a simple query on the workstation's Query Browser will return results in about 15-20 sec however the server reports "3 rows fetched in 0.0136s (0.0016s)" . This would indicate that the query was very fast once the client communicated with the server.
The time to login suffers similar delays. Very fast on server, same 15-20 sec delay at the workstation. Something appears to be timming out somewhere.
A server host IP (not server name) is used to login.
The w2k server and w2k workstations are on a test network so any mis-setting is possible.
New at MySQL so not sure of where to start or what tools to use to troubleshoot this one. Probably not a simple problem.
Thanks in advance,