Solved

Speed issues in connection MYSQL in 2003 server from workstation

Posted on 2007-03-27
3
274 Views
Last Modified: 2013-11-13
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
Comment
Question by:sara_lcc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 30

Accepted Solution

by:
todd_farmer earned 500 total points
ID: 18806184
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

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Import MySQL data into MS Access using VB.Net interface 5 51
Delete Disconnected Site from Active Directory 3 60
learn programming 8 69
SSIS Paramater on start 2 25
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question