Path: csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Robert Klemme Newsgroups: comp.lang.java.programmer Subject: Re: Slow Query Execution between two Servers Date: Tue, 15 May 2012 08:16:53 +0200 Lines: 22 Message-ID: References: <2cc4e775-ff85-40ec-8f50-afad1d13c9f3@to5g2000pbc.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net Ef1f14JlS6CERN5zj/VbGgUKO9IG88591iybBRXjoChy8IH9OucuJY9BC6J6onGTw= Cancel-Lock: sha1:Hs5V6XC0dkC7ECIkpP4LJHmacPY= User-Agent: Mozilla/5.0 (Windows NT 6.0; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 In-Reply-To: <2cc4e775-ff85-40ec-8f50-afad1d13c9f3@to5g2000pbc.googlegroups.com> Xref: csiph.com comp.lang.java.programmer:14542 On 11.05.2012 06:51, George wrote: > I am using Application in one Server and MySql DB in another > server(Both are Linux). I am using the InitialContext and Datasource > for connection using java.Here my problem is Slow in Query execution > while calling from the application server. While I deploying the > application and the MySql in the same server it is fast. Here I am > using the LAN IP between two servers. How can I resolve this? If you suspect it's the network then you could do a network trace and look at the timing. Or use other network analysis tools. You might also want to have a look at network buffer size settings. IIRC defaults in Linux are fairly low and if you transfer large query results buffer sizes can have an impact. Kind regards robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/