Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

Speed issues in connection MYSQL in 2003 server from workstation

hi all,
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?

Pls help.
Steve.
0
sara_lcc
Asked:
sara_lcc
1 Solution
 
todd_farmerCommented:
Check your DNS configuration.  The JDBC driver uses TCP, and Sun's implementation does reverse DNS lookups that can cause the process to hang with poorly configured DNS.  Attach a profiler to your application to see where the hang happens - I would bet that it's in the Sun code related to DNS lookups.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now