Speed issues in connection MYSQL in 2003 server from workstation
Posted on 2007-03-27
we are develovping a software it is client server software. Database is MYSQL and the clinet application is designed using JAVA, when we are installing database & application in any standalone PC either XP or 2000 or 2003 it is working fine. If we want the s/w from different location we are installing only the clinet application in all computers we are accessing the databse using the ip of the computer in which we installed the MYSQL, in this also we dont find any problem.
If we install the MYSQL in Linux Server or Windows 2000/2003 Server and if we access in other computers using the same method(Using the server ip), the processing becomes very slow. It takes 3 mts even for the login screen verification.
How to avoid this, how to increase the speed same lile using with Normal usage in XP, Do need to set any rights in windows 2003 server. Is there any things to be done for increasing the speed?.
In both workstation as well in server firewall is disabled and tried removing all Antivirus from server and client computers.
How to do now?