Solved

Speed issues in connection MYSQL in 2003 server from workstation

Posted on 2007-03-27
3
271 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Advice in Xamarin 21 78
How to get time difference in minutes and seconds only between 2 dates 2 40
UPDATE query not working in mysqli php 8 48
MS Endpoint Protection 2 19
Learn about cloud computing and its benefits for small business owners.
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…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

813 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now