Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.mixmin.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Robert Klemme <shortcutter@googlemail.com>
Newsgroups: comp.lang.java.programmer
Subject: Re: Slow Query Execution between two Servers
Date: Thu, 17 May 2012 11:16:28 +0200
Lines: 21
Message-ID: <a1jtvcFd2jU1@mid.individual.net>
References: <2cc4e775-ff85-40ec-8f50-afad1d13c9f3@to5g2000pbc.googlegroups.com> <a1eamsF42kU1@mid.individual.net> <fb27r7dhtg41g5mfn314hjhu4foq7rp0fg@4ax.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net aotvrEuV4UqVOLWk/E+XmgI0sk430Ylp0yr8otaVIkZS+Ee4gEhYfWdghSMyWIyKk=
Cancel-Lock: sha1:D1M6r5X3mIfN6LxmjoYy+Ae6seo=
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:12.0) Gecko/20120430 Thunderbird/12.0.1
In-Reply-To: <fb27r7dhtg41g5mfn314hjhu4foq7rp0fg@4ax.com>
Xref: csiph.com comp.lang.java.programmer:14570

On 05/16/2012 01:05 PM, Roedy Green wrote:
> On Tue, 15 May 2012 08:16:53 +0200, Robert Klemme
> <shortcutter@googlemail.com>  wrote, quoted or indirectly quoted
> someone who said :
>
>> If you suspect it's the network then you could do a network trace and
>> look at the timing.
>
> You might try a free program called TCPOptimizer to suggest the best
> settings to tweak your TCP/IP. http://www.speedguide.net/downloads.php

Roedy, how should that help OP?  He said

> I am using Application in one Server and MySql DB in another
> server(Both are Linux).

Better look in the wireshark, pcap, tcpdump area.

Kind regards

	robert